Copy data from specific sheets from one workbook to another

M

mtuohey

I'm new to programming in Excel and I have a specific project I could use
some advise on.

I have a need to be able to copy specific columns (qty. 3 - 10) from
specific worksheets (qty. 5) from one workbook to another.

So my data will come from something like this,

SourceWorkbook
Sheet1
Column A
Column B
Column C
Sheet2
Column B
Column E
Column G
Sheet7, etc. etc.

The columns will always be in the same locations within the specific
worksheets, but the workbooks they are in may vary. I need a way to pick the
workbook I want copied from.

The destination workbook, sheets and columns would not change from each
execution.

Can anyone recommend a resource on how I can figure out how to do this? Or
if it is even possible?

Hope this makes sense.

Thx.

mtuohey
 

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

Need Help with a VBA subroutine 0
How to copy files from Onedrive account to another 2
List all tables, including document structure 0
Format column widths from one table to a separate table on same page 1
Copy columns and paste with blank column between 5
Copy addition formula of non-consecutive horizontal cells 2
Macro to Select text from a point given to a specific word 2
Macro to Format Multiple Sheets based on "Master" Format 0

Top