worksheets

G

GarryC

Thanks Julie

What I meant was that I have two different worksheets on different disks.
One is 2nd quarter reporting and the other is a 3rd quarter reporting with
the same template.
I want to combine the two reports to go one one disk and worksheet.

Thanks
 
J

JulieD

Hi Garry

firstly, i'm concerned about things (ie workbooks) being on separate
"disks" - it is never a good idea to run an excel workbook (or any other MS
document) directly from a floppy disk - please copy them onto your hard
disk - work on them off the hard disk and then copy them onto a backup
medium (floppies aren't really a reliable medium).

As to how to set up your workbook with them combined - it really comes down
to WHY do you need (want) to combine them - how many columns of information
does each workbook have - and what do you want to see when you look at the
workbook etc.
If you want to be able to compare easily 2nd & 3qtrs and you only have a
couple of columns of information - then a simple copy & paste of the 3qtr
figures to columns adjacent to the 2nd qrt should give you what you're
after - or am i misunderstanding something.

Cheers
JulieD
 
Top