Is there a way to combine two spreadsheets but only bring over certain
columns. I have a master spreadsheet that I want to bring over certain
columns from other spreadsheets because I have formulas in my master
spreadsheet that I don't want to redo every time I combine the spreadsheets.
I don't want to copy and paste because there can be hundreds of lines and up
to ten column. I want a macro or something that would not take too long to
bring over just the columns I want over to my master spreadsheet.

Hi,

We really need to know what your data looks like in both the source and
target sheets to give you a solid answer. You may be able to use the Edit,
Paste Special, Skip Blanks command. you may be able to select non-contiguous
ranges and copy and paste them, it all depends on exactly what you have and
need. Also, to program this - programming is about details.

You might be able to record the step you would do manually for a macrol.

--
Thanks,
Shane Devenshire


"MAD101" wrote:

Is there a way to combine two spreadsheets but only bring over certain
columns. I have a master spreadsheet that I want to bring over certain
columns from other spreadsheets because I have formulas in my master
spreadsheet that I don't want to redo every time I combine the spreadsheets.
I don't want to copy and paste because there can be hundreds of lines and up
to ten column. I want a macro or something that would not take too long to
bring over just the columns I want over to my master spreadsheet.