Difference in speed copying an entire table vs a select number of rows?

Hi all,

I have a macro which basically copies auto-filtered data from table 1 to a new table. It works great.

I'm now interested in making a comparison between table 1 and table 2. They have the same layout. So, I would want to copy both table 1 & 2 to a new sheet (as two tables or into two tables next to each other). Calculations would be like Column A table 1 - Column A from table 2. This would then be done in a new table or area to the far right.

As you can see below, the macro copies the entire range from A:AV. That's 47 columns, I think.

In actuality, I may only really be interested in say 15 columns in total. The problem is of course that they're not adjoined and I may want say column D, I, M, S and X instead of a continuous range of columns.

For me, who's not a good coder, it might be best to simply copy A:AV from both tables into a separate area each and then add a new table which extracts data from each copied table and makes calculations.

For me, that works fine if the speed isn't an issue. Of course, the sheet may become fairly large, but I imagine that should not be a big issue.

The question I have then is if it's worth improving this macro to copy a select number of columns or if I should just go with copying the entire table?

Copying the entire table seems to happen fairly fast, so it might not be an issue to worry about.

Thanks in advance for all help and pointers.

Please Login or Register  to view this content.

Okay. So this is the solution I came up with.

Basically, one macro which runs two macro where each copies data to a table each. To the far right is a third table which compares data from the two tables. I may choose a different layout. For example copy these two tables to the far right and have my 'comparison' table to the far left.

Two workbooks attached. Both macros run from PartDay2. It takes about 2 seconds for a full table. I think I can live with that.

Thoughts/improvements?

Thanks in advance.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.