Compiling data from multiple work sheets.

**Dumori** · 06-24-2008, 06:09 PM

Hi I'm having trouble making a printable/exportable summary page for an excel sheet I'm working on.

This sheet has multiple worksheets each with a similar format but there not identical dealing with different products. I want to have a worksheet that posts all the rows with an amount more than 1. And under set headings identical to the ones in the worksheet. I can link to the sheet if needed as its nothing important data wise.

I was wondering how I could do this I may need to use macros or VB but I am unsure.

Thanks for any help.

**Richard Buttrey** · 06-24-2008, 06:37 PM

Hi, welcome to the forum.

It's probably easier for us to offer a solution if you attach your workbook in the forum.

If it's sensitive data then anonymise it, and if it's very large delete all but a sample of the data. Add some notes describing the cells you want to deal with and the results you expect and I'm sure someone will be along to help.

Rgds

**Dumori** · 06-24-2008, 07:29 PM

OK then here is a link to a version of the sheet.
http://dc81.2shared.com/download/347...75808-5473a182

All though it looks big is only about 500Kb.

**Richard Buttrey** · 06-24-2008, 07:56 PM

When you say you want all rows with an amount more than 1, how are you defining 'amount'. Are these all the columns headed "Total"?

Then what data do you want included on your summary sheet? Since the column headings are significantly different, how are you expecting them to line up?

Can you provide an example of the summary layout you're looking for?

Rgds

**amreen.chugh** · 06-25-2008, 01:27 AM

Hi Dumori,

I have written a Macro 'compile_final'. This compiles the data from the first five worksheets and inserts the results into a sheet named 'Final'.

Since, the code for each sheet remains the same, you can implement it for the rest of the sheets yourself.
Since, the value of 'Total' in each of the first five sheets is 0, I manually changed the values during debugging. This has been done to display the layout of the complied data which is in the sheet "Final".

Please have a look at the attachment.

Regards,
Amreen

**Chrysalis** · 06-28-2008, 05:34 AM

Hi all,

I am the other developer and I did try your macro Amreen, very neat of you.

However, for some reason I am only getting errors. Could you have a look at it again?

Please find attached an example summary sheet below and the resource sheet here:

http://www.2shared.com/file/3510765/...220608-02.html

What I would like to see is that when the value in amount becomes 1 or greater it is added to the summary sheet. In addition row 5 of the worksheet is added. I have also attached the updated sheet with cells with costs and totals falling into the correct columns.

Thanks,

-Chrysalis

**Tafhim** · 10-23-2012, 06:39 AM

Bogus link, does'nt opens

**smithtronics** · 10-24-2011, 06:19 PM

I would like to have help in trying to make a final page that adds up all totals in other tabs in the same workbook,

I have uploaded my document. I would appreciate any help you can offer.

thanks again

Rick

**ConneXionLost** · 10-24-2011, 06:29 PM

smithtronics,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.