Copying worksheets

L

Lee Kelly

I have this formula in a range of cells on worksheet 1-
Titled "Ledger"

=IF(SUMPRODUCT(--('WE 30.07.04'!$A$6:$A$82=4),--('WE
30.07.04'!$C$6:$C$82=$A8)),"X","")

'WE 30.07.04' refers to worksheet 2.

My problem is this.

I have copied worksheet 2 to create 'WE 06.08.04' but now
the formula above will only pick up data from worksheet 2
and I need it to pick up the data from both sheets plus
all other sheets I copy in future.

Is there any solution to this problem?

Thanks in advance

Lee
 

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

Can a formula look for data in a number of worksheets? 4
looking at for the latest date 1
Searching for multiple conditions 1
Formula for looking up and copying from another worksheet? 1
Syncing between source worksheet and dependent worksheets 0
Display "/" (slash) as a character, not as an action (divide) 5
Multiply with Vlookup value from another Worksheet 0
Transferring only certain rows to seperate worksheet 4

Top