Hello,
I'm wondering if there is someone who could assist me in creating a Macro for a worksheet however I do not know if it is even possible.
I would like to have a macro which pulls the values in specified columns if a specific criteria is met in one of the columns.
For example:
If value in column P is equal to "03-GAYLEA" from worksheet Sunday through Saturday (7 worksheets) then..
Copy data from A1 in source worksheet to Column A6:A72 (First empty cell) in "Gaylea Tracking" worksheet
Copy data from column E in row of source worksheet over to Column C6:C72 (First empty cell) in "Gaylea Tracking" worksheet
Copy data from column K in row of source worksheer over to Column E6:E72 (First empty cell in "Gaylea Tracking" worksheet
Copy data from Column O in row of source worksheet over to Column B6:B72 (First empty cell) in "Gaylea Tracking" worksheet
Basically I need to pull data across an entire workbook for an entire week and compile it in a separate worksheet within the same excel workbook but not all of the data in the row is needed, just specific values and only if column P = "03-GAYLEA". It does not matter whether this is a search for string macro or anything I just wanted to see if this would be possible.
Bonus if it can be pulled in order from the worksheet but I can easily add a sort on the final worksheet by date.
Appreciate any input, thanks!
Josh
I'm wondering if there is someone who could assist me in creating a Macro for a worksheet however I do not know if it is even possible.
I would like to have a macro which pulls the values in specified columns if a specific criteria is met in one of the columns.
For example:
If value in column P is equal to "03-GAYLEA" from worksheet Sunday through Saturday (7 worksheets) then..
Copy data from A1 in source worksheet to Column A6:A72 (First empty cell) in "Gaylea Tracking" worksheet
Copy data from column E in row of source worksheet over to Column C6:C72 (First empty cell) in "Gaylea Tracking" worksheet
Copy data from column K in row of source worksheer over to Column E6:E72 (First empty cell in "Gaylea Tracking" worksheet
Copy data from Column O in row of source worksheet over to Column B6:B72 (First empty cell) in "Gaylea Tracking" worksheet
Basically I need to pull data across an entire workbook for an entire week and compile it in a separate worksheet within the same excel workbook but not all of the data in the row is needed, just specific values and only if column P = "03-GAYLEA". It does not matter whether this is a search for string macro or anything I just wanted to see if this would be possible.
Bonus if it can be pulled in order from the worksheet but I can easily add a sort on the final worksheet by date.
Appreciate any input, thanks!
Josh
