I am using VBA to filter and copy data from a Source Workbook and paste it into a Destination Workbook. The Source Workbook has three worksheets. Each has the same column layout, but with different sets of data. I will be copying data from each of the three worksheets into three tables in the Destination Workbook, with a blank row between each set of data. My filter and copy code works fine; it's the pasting I am having issues with.
Each worksheet in the Source Workbook uses a different color scheme, as well as conditional formatting such as Icon Sets. As the number of rows in the filtered results can vary, I cannot use conditional formatting on the Destination Worksheet as the three tables are not a fixed size.
I wish to retain the values and source formatting, but NOT the Names found in the Name Manager of the Source Workbook. Do I have any other options than to rename the conflicting names in the Source Workbook?
Each worksheet in the Source Workbook uses a different color scheme, as well as conditional formatting such as Icon Sets. As the number of rows in the filtered results can vary, I cannot use conditional formatting on the Destination Worksheet as the three tables are not a fixed size.
I wish to retain the values and source formatting, but NOT the Names found in the Name Manager of the Source Workbook. Do I have any other options than to rename the conflicting names in the Source Workbook?
