Getting data from several worsheet/books

  • Thread starter Thread starter CS
  • Start date Start date
C

CS

I have 2 workbooks with multiple worksheets. They all
contain columns of data labelled PartName and PartID
(along with other columns). I would like to get all data
from these 2 columns and put them in one spreadsheet. Is
there a way to merge this info other than copy/paste to
new worksheet? Thanks
 
I'm sure there are lots of alternatives, but I would write
a Visual Basic macro to do the job. You didn't mention if
you can write macros or not. If you can't you should put
some time in learning . . . it will solve a lot of problems
like this.
 
Thanks for the suggestion. I guess it's time to learn how
to write macros.
 
A couple of suggestions...first, search for posts that seek to
accomplish tasks similar to yours and study the replies. There is a
wealth of insight in many of the existing threads. Secondly, try to
organize your thoughts and offer more information so others know what
you are trying to achieve. And lastly, experiment with what you find -
and don't give up.
Best wishes...Mike
 
You must log in or register to reply here.

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

Excel 2013 Merge Data 2
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Find a value in a sheet and replace it with another value if it matches 8
error trying to sort data 4
Import multiple workbooks to current workbook in specified row number 0
Create Workbooks and Copy Template Worksheet to those Workbooks 12
Copy data from 1 sheet to multiple worksheets 2
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top