Copying columns from multiple sheets in a single sheet based on a column value.
Hello,
This is tricky to explain... Lets say I have 6 worksheets, "apples", "oranges", "pears", "basket1", "basket2", & "basket3". The "basket1", "basket2", & "basket3" sheets contain information in column format were one of the values in the column will be the type of fruit and then the rest of the values in that column will be about that particular piece of fruit. I need to copy only the columns out of worksheets "basket1", "basket2", & "basket3" that have the value "apple" in say row 2 - and paste those values into the "apples" sheet. Then repeat for the "oranges" & "pears" sheets. Thank you in advance for you help. Starla |
Copying columns from multiple sheets in a single sheet based on a column value.
|
All times are GMT +1. The time now is 01:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com