R
Ray
I've built a summary workbook to consolidate data gathered from approx
30 external workbooks. I've built a way to easily identify which (if
any) external workbooks were not updated on time -- an Advanced
Filter, using VBA. So, now I have a range of cells (Sheet='Admin',
range=G38:H68) which will hold the Store Name/# of those who didn't
submit on time. The 'used' part of this range will likely change with
each update (eg 5 stores are late this time, but only 2 next time and
none last time).
What I want to do is have a button on the Dashboard (what I call the
main sheet) which will allow users to see a list of the
'offenders' ( ie those that didn't send an update). This would be in
a pop-up window or userform, and only show the 'used' range (as
mentioned above) .... just two columns containing Name and Number of
the non-updaters.
How would you code this?
TIA,
ray
30 external workbooks. I've built a way to easily identify which (if
any) external workbooks were not updated on time -- an Advanced
Filter, using VBA. So, now I have a range of cells (Sheet='Admin',
range=G38:H68) which will hold the Store Name/# of those who didn't
submit on time. The 'used' part of this range will likely change with
each update (eg 5 stores are late this time, but only 2 next time and
none last time).
What I want to do is have a button on the Dashboard (what I call the
main sheet) which will allow users to see a list of the
'offenders' ( ie those that didn't send an update). This would be in
a pop-up window or userform, and only show the 'used' range (as
mentioned above) .... just two columns containing Name and Number of
the non-updaters.
How would you code this?
TIA,
ray