B
Bannor
Hi!!
Is there any way to sort multiple worksheets in a workbook simultaneously
(ie instead of sorting each sheet individually)? I have a file with 30+
sheets, each sheet set up identically (ie the same data type in the same
column on each sheet), but (obviously) containing different data.
There's a complication as well - each sheet has 50 rows, comprising links to
other files. Not all of the rows actually contain relevant data (ie in some
rows the result of the link is 'zero'), but the rows that contain data come
before any rows that do not. For example, on sheet 1 (even though, as I have
said before, all 50 rows containa formula - a link to another workbook), the
top 40 rows actually contain values. On sheet 2, only the top 24 rows contain
data. On sheet 3, the top 43 rows contain data... And so on for the other
sheets. And periodically, I will add additional sheets.
I need to sort each sheet by the same data (ie by the same column), in
descending order, but don't want to go to each page and perform a sort.
Surely there is a way to sort all the pages simultaneously?
All help will be very much apprecialted!! Thankyou!!
Is there any way to sort multiple worksheets in a workbook simultaneously
(ie instead of sorting each sheet individually)? I have a file with 30+
sheets, each sheet set up identically (ie the same data type in the same
column on each sheet), but (obviously) containing different data.
There's a complication as well - each sheet has 50 rows, comprising links to
other files. Not all of the rows actually contain relevant data (ie in some
rows the result of the link is 'zero'), but the rows that contain data come
before any rows that do not. For example, on sheet 1 (even though, as I have
said before, all 50 rows containa formula - a link to another workbook), the
top 40 rows actually contain values. On sheet 2, only the top 24 rows contain
data. On sheet 3, the top 43 rows contain data... And so on for the other
sheets. And periodically, I will add additional sheets.
I need to sort each sheet by the same data (ie by the same column), in
descending order, but don't want to go to each page and perform a sort.
Surely there is a way to sort all the pages simultaneously?
All help will be very much apprecialted!! Thankyou!!