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.