Joining only certain columns to a spreadsheet.

M

MAD101

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.
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locating Source Data in Master Spreadsheet 3
Locking columns 3
Appending Data from one spreadsheet to another 4
Select Range based on column name and not A1 notations 3
How do I consolidate data from several spreadsheets into one. 4
Excel 2007 spreadsheet references older office spreadsheets 2
how can I combine multiple worksheets into a single workbook? 5
merging spreadsheet data 1

Top