Merging Different worksheets

G

Guest

Hi

I am trying to merge two worksheets with some columns having the same
heading while others have a different heading into a single worksheet. See
the example below:

Worksheet 1:
Server Name......Server Use......Server Location.......Memory

Worksheet 2:
Server Name.....Server Use.....Server Owner....Comments

Expected Single Worksheet:
Server Name...Server Use....Server Location....Memory....Server
Owner...Comments.

I would like to do this without lossing any data. Can anyone help?
 
G

Guest

Hi is there any way to put markups into the program so that I can select
which row to start with and which row to end with. thanks
 

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

merging workbooks 1
Merging data from different worksheets 1
How do I lookup data from multiple worksheets? 2
Merging two worksheets that have a common field 4
Matching Columns in work sheets and copying both rows to new 1
Pull info from multiple worksheets into one Master 2
Is it possible to Append worksheets in the same excel file? 3
Linked cells between worksheets and sorting 2

Top