Hi everyone...
I have the following challenge, which is rather for presentational issues.
I have like 5-10 spreadsheets that contain eg the same range of products. (say product 1- 20)
My problem is that in some projects i do not use all the lines as it is a template...so sometimes i may need to use 10 out of those 20 lines full of formulas ..and maybe some #NAs... looks bad ..so every time i have to go back and hide them by grouping.
so, what i want to do ..is save time by group/ungroup in ALL spreadsheets (for the specific range where the product row lines are) by saying if() cell is not empty in my main product list sheet :
(so in reality, instead of going every time i use this template to group ungroup for ten twenty sheets ... i figure i can save time by having one sheet as my main eg "product sheet" and by looking if i have entered values in those rows... display the same range in the other sheets.
eg
Main Product list Sheet
#1 product 1
#2 product 2
.
.
.#15 product 15
The range of that 'table' let s assume is 25 rows
------
then, i want the rest of the sheets (could be 10 sheets) in that workbook to have those 15 rows displayed and group the rest of the 10 rows (ie hide them)
bad thing is that it has to be a constant process...sort of like on every change of the main list..and reset obviously previous grouping if that was the case.
if you have ideas ... more than welcomed.
could be macros or not...
I include a simplistic attachment for your convenience...to get an idea..
by the way the products may be split in two groups vertically as in the book..i don t know if that might cause a coding issue.
Appreciate your help
Bookmarks