Excel help Required.

stevet

Established member
917 5
delboy trotter

easy way is to employ a programmer on 50 - 100K a year! although i guess i can see the downside to that one!
 

TBS

Well-known member
385 0
Why not just set it up as a vlookup table, then you will only report the data for the dates that you want?
 

delboy trotter

Active member
112 2
"Why not just set it up as a vlookup table, then you will only report the data for the dates that you want?"

Yes TBS that's what I mentioned a the start of the thread, but I could not get my head round how to do that. How do you do it?

regards,

dbt
 

mutantcar

Active member
123 0
DelBoy,

If you haven't solved it yet, have you tried 'Data-PivotTable' with 'Multiple Consolidation ranges'.

If you're not sure, send me some sample data & I'll give it a go.

Cheers,

Mute.
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock