ExcelBanter - Data reports

There are several ways to do it.
1) Copy the data you want into a sheet. Select the range and use Edit Copy,
Edit Paste function
2) Using Paste Link function, Everytime your cell value in a sheet changes,
the link cell value will change.
Example : Your file name is abc.xls, under sheet 1 cell a1 has a value 123456
You want it show at file name result.xls under sheet 1 cell b11
GO TO abc.xls sheet1, cell a1 - Select Edit Copy
GO TO result.xls sheet1 cell b11 - Select Edit Paste Special Click Button
Paste Link
As you may have many cells to link, let me explain the link formula for you
to see if it helps. You would see the below formula at results.xls sheet 1
cell b11 after linking. To edit the formula, you press <F2
='[abc.xls]Sheet1'!$B$11
Delete the $ sign. ($ sign means absolute )
(To see the differences, you could copy the cell 11 to cell 12 with/without
$ sign formula.)
3) Using Macro function - as your requirement is not details and you mention
you are new, I will not explain to you here.

Hope this helps you
Anna
"Disp4115bh" wrote:

I am trying to compile the data from multiple sheets into one report. I have
multiple worksheets of the same sheet with different responses/answers. Is
there anyway to make one report (say monthly or quarterly) where the data is
combined from all worksessions? Thanks. I am new at Excel.