Macros

  • Thread starter Thread starter Chillax
  • Start date Start date
C

Chillax

Situation: Workbook with four sheets (each sheet represents a different
subject); I have one master sheet that needs to be auto-updated with the
information on those four sheets.

What is the best way to design a macro that can handle this?
 
Chillax,
What is the best way to design a macro that can handle this?
Click to expand...

The best way is to not use a macro, and only use the master sheet. And add a column where you enter
the 'subject' for each record. Then you can filter your data set based on that column, showing only
the data asscociated with the 'subject' of interest.
 
Back
Top