how to copy from one workbook to other when the main one have several filters

[luis6777]

Good afternoon

I was wonder if someone could help me, im trying to cope data from one workbook to other, my problem is that the first workbook have macros to filter the data in several ways.
How can i copy that data from one workbook to ther and keep the data up to date when several filters are done in the main workbook

Thanks in advance

[alansidman]

How can i copy that data from one workbook to ther and keep the data up to date when several filters are done in the main workbook

I am not sure what you are trying to tell us here. Maybe, when you copy the data, and it has formulas in it, you want the data hard coded and not formulas? Also, it will help if you upload a copy of the workbooks.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[luis6777]

HI

I think i was able to make it, attached 2 workbooks
Workbook_1 have the original data with the macros to filter that data (copy of the macros in the second sheet)
Workbook_2 is showing exacly the same data but no macros and it is depending of Workbook_1

I would like to be able to copy the data from Workbook 1 to workbook_2, but when filtering the data on workbook_1 the data on workbook_2 will need to be correct ie: the holidays will need to be assigned to the correct individual in the correct days. but withoyt changing the order on workbook_2

I hope that it makes sense

[luis6777]

Does anyone can help with the above issue

Thanks