Getting data from several worsheet/books

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
 
S

SidBord

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

Mike Taylor

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
 
Top