Summarise Worksheet Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a spreadsheet that has worksheets names 06180 to 06189. I want to
create a summary worksheet of some of the data. The worksheets are identical
and the data that I want will always be the same.

The worksheets are named 06180 to 06189.

Date (H7)
Supplier (B8)
Purchase Order Number (H9)
$ Amount (P40)

I have not used macros or VBA before and I am thinking this is the only way
to be able to summarise the data that I want.

Also at the end of every month we use a new spreadsheet so how do make it so
its easy for me to change formulas etc for a new spreadsheet??
 

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

Summarising Worksheet Data 4
Macro and automatic update 3
HELP -> Perl 'Hash' Functionality Required In VBA 11
summarise multiple worksheets 1
Summarise data from several worksheets in a workbook 2
Macro's - inserting a worksheet and having upload data 2
Copy two summary ranges to master summary sheet 5
Copy row 21 from all sheets to a new sheet except " summary" 3

Back
Top