Newbee question (Adding Workbooks)

[Adam Familia]

May I ask for some assistance please.

I have created 2 excel workbooks. Examples.. January, and February records.
Both workbook have 1 spread sheet inside. How do I add February spread sheet
into January workbook? I tried copy and paste the Febuarary spread sheet
into a new sheet on the January workbook, and format looked terrible. Also,
I tried using the insert option, but it doesn't allow to browse for my
Febuarary record. I hope this makes sense.

Is there a way to add these two workbooks together into one?

Thank you in advance!

Adam

 

[Ragdyer]

Open both WBs.
Right click in one of the sheet tabs and choose "MoveorCopy".
Expand the "To Book" box, and click on the other WB's name, then <OK>.

And you should now have both sheets in the same WB.

 

[Earl Kiosterud]

Adam,

Not only should you combine the workbooks, you may well be best served by
combining them into one sheet. See
www.smokeylake.com/excel/excel_truths.htm. Read "Data across multiple
tables."

 

[Adam Familia]

Thank you guys for responding to my post. That's what I needed!!

Adam