Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I would like to pull data from one exel worksheet to another. Basically, I have a series of headings in column B and would like to pull the contents of a row in a different worksheet under one of the headers in column B depending on the contents of a specific cell in the row. For example, if the contents of the cell D5 = â??yellowâ?? then the whole of row 5 appears under the heading Yellow on the other worksheet. If the contents of D6 = â??blueâ?? then the contents of the row 6 appears under the heading blue on the other worksheet. Objective is to have all of the yellows and all of the blues under the correct heading on the other spreadsheet.
Solved by I. E. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/04/2018 - 07:08
Hi…Welcome to Got It Pro
Excelchat Expert 24/04/2018 - 07:08
could you please share a sample of your data in this blank sheet?
User 24/04/2018 - 07:11
I would like to create a separate worksheet with the cells under 'IMASector' as headings in column B. I would them like to pull all of the rows into the new worksheet under the correct IMASector
Excelchat Expert 24/04/2018 - 07:12
please look at sheet2
Excelchat Expert 24/04/2018 - 07:12
is it something like that?
User 24/04/2018 - 07:13
Not quite, let me edit it to show you what i mean
Excelchat Expert 24/04/2018 - 07:13
sure
User 24/04/2018 - 07:18
A little bit like that (but for all rows)
Excelchat Expert 24/04/2018 - 07:18
ok...you can do that with pivot table
Excelchat Expert 24/04/2018 - 07:18
let me show you
User 24/04/2018 - 07:19
Thanks
Excelchat Expert 24/04/2018 - 07:21
please look at pivot table sheet
Excelchat Expert 24/04/2018 - 07:21
This also does a subtotal of each IMASector
User 24/04/2018 - 07:22
That's pretty much what I am looking for. Is it possible for the pivot table to automatically update if the data is changed in the spreadsheet?
Excelchat Expert 24/04/2018 - 07:23
yes, you will just need to refresh the pivot table and it will automatically update
Excelchat Expert 24/04/2018 - 07:23
You will just need to make sure you are taking the complete range of your data in your pivot range
Excelchat Expert 24/04/2018 - 07:24
If you click on Pivot, pivot table editor shows up
User 24/04/2018 - 07:24
Thanks, that's really useful.
Excelchat Expert 24/04/2018 - 07:24
and pivot source range reads as Sheet1!A1:E21
Excelchat Expert 24/04/2018 - 07:24
so we are taking data from A1 to E21 from Sheet1 for now
Excelchat Expert 24/04/2018 - 07:24
you will need to change this range if your data explands
Excelchat Expert 24/04/2018 - 07:25
and that's it you just refresh your pivot and it updates automatically with new data
Excelchat Expert 24/04/2018 - 07:25
Does that solve your query?
User 24/04/2018 - 07:26
Yes it does, thank you.
Excelchat Expert 24/04/2018 - 07:26
Is there anything else I can help you with this query?
User 24/04/2018 - 07:26
no thank you
Excelchat Expert 24/04/2018 - 07:26
Please do give me a good feedback for my service.
Excelchat Expert 24/04/2018 - 07:26
Thanks for your time. Please do come back for any new question. Have a great day ahead!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.