Copy by criteria in two worksheets into the 1st work sheet

[city]

Hi All,

Good Morning! I needed help on creating a macro that copies all names from Cell B in the MainPage worksheet and Senior Worksheet
into the Mainpage worksheet Cell (P) given that the late considered (Cell J) is equal to "Y".

At the same time it also copies the data to DB sheet. Please review and advise. Thanks

copy critieria.xlsx

[tigeravatar]

city,

Give this a try:

Please Login or Register  to view this content.

[city]

Thanks for the quick response. The code works. The only problem Im currently getting is for the MainPage Sheet.
it should only copy the values with Y in the MainPage worksheet only into Cell (P) of MainPage

[tigeravatar]

Oh, I see, you don't need the items from the 'Senior' sheet listed on the 'MainPage' sheet.
Updated code:

Please Login or Register  to view this content.

[city]

Thanks for helping me out tigeravatar. Im really having problems with this part of the code

Please Login or Register  to view this content.

What if I want it to be in the middle of the spreadsheet?
for example I have another table before the tardiness table and I need to copy those data in that table. .

[tigeravatar]

city,

I'm not sure what you just said. If you don't want to use Rows.Count, replace that with the row number to start at. For example

Please Login or Register  to view this content.

[city]

It always copies the data in the last cell that has a value. im trying to learn the code. Thanks for the prompt responses. Really appreciate it.


I added another table under the agents tardy table. When I run the macro it copies the values (agents tardy) in the absents table.



See attached file.

copy critieria.xlsm

[tigeravatar]

city, I wouldn't recommend having a table underneath another table. I would instead recommend they be adjacent to each other, or on separate worksheets. Then you can change the destination column, or the destination worksheet which is much easier and adaptable than adjusting the code to put items in the tables that are on top of each other. It also doesn't limit the amount of rows the top table can hold, because there won't be a table beneath it.

[city]

Just curious. I actually wanted to apply the code to a different type of report. Anyway. Thanks for the help tigeravatar. This code really helped me.