Hello all,
First post. Thank you in advance for your help. I appreciate the effort, and forums like this are really great.
I am looking to add some functionality to a workbook I am working on, and hopeful that someone may be able to help.
I am looking to identify multiple rows, across multiple sheets, and paste those into a new sheet. The idea is to aggregate specific data into a central location.
I'd like the function to do the following:
1. Identify if column D has an 'x' in it
2. If 'x' is present, select and copy columns B through O for the specific row
3. Paste columns B through O for the row into the new sheet
4. Move on to the next worksheet and repeat
5. Continue until all worksheets have been "parsed" and aggregated
I found a couple macros that have moved me in the right direction, but I cannot seem to get the functionality to work quite right.
Any help would be truly great. If you do provide code, if you could provide comments on what each line does, that would be very helpful for me so that I can learn how it works, and make edits as needed.
Thanks again. Much much appreciated.
--Sam
Bookmarks