S
shawb
That doesn't seem to work as the paste sends a #REF into the offset o
paste so the formula becomes =IF(OFFSET(#REF!,0,-1)>0,1,0) on the righ
which returns the #REF error.
Think solution would be easier to solve with a macro executin
everytime an update occurs maybe?.
There's got be a way to do it cause I have seen a worksheet where i
works and I don't believe it is likely it was done with macros.
(sidenote, database is a central one used to modify other worksheet
using macros. Each of these worksheets uses different sets of filters
The data pane on the right records subtotal and totals critical to th
filter. one set of fields in the data pane records the start pt and en
pt of where to copy from in the main database to the target worksheet
These start pt and end pts are calculated from a column next to col
which records the running total of 1's, so you see to modify col4 woul
require me to a lot of recoding to fix all my worksheets macros
paste so the formula becomes =IF(OFFSET(#REF!,0,-1)>0,1,0) on the righ
which returns the #REF error.
Think solution would be easier to solve with a macro executin
everytime an update occurs maybe?.
There's got be a way to do it cause I have seen a worksheet where i
works and I don't believe it is likely it was done with macros.
(sidenote, database is a central one used to modify other worksheet
using macros. Each of these worksheets uses different sets of filters
The data pane on the right records subtotal and totals critical to th
filter. one set of fields in the data pane records the start pt and en
pt of where to copy from in the main database to the target worksheet
These start pt and end pts are calculated from a column next to col
which records the running total of 1's, so you see to modify col4 woul
require me to a lot of recoding to fix all my worksheets macros