N
Number1Dub
HI
I have a 3 page worksheet listing all the schemas I maintain, with each page
representing a different view; by DB type, region, customer etc. Each sheet
is exactly the same except for how the data is ordered (by DB, region etc).
Is there a way that I can update the data in sheet #1 and then have it
automatically update the other two sheets? I've tried to find the info
online, no joy, and I've also tried playing around with references, but can
only get it to work for individual cells
Thanks
No1Dub
I have a 3 page worksheet listing all the schemas I maintain, with each page
representing a different view; by DB type, region, customer etc. Each sheet
is exactly the same except for how the data is ordered (by DB, region etc).
Is there a way that I can update the data in sheet #1 and then have it
automatically update the other two sheets? I've tried to find the info
online, no joy, and I've also tried playing around with references, but can
only get it to work for individual cells
Thanks
No1Dub