How do I set up a Workbook with a master compiled worksheet and o.
I want to set up a workbook that has several worksheets in it BUT!!! I want
the information from these multiple worksheets to be compiled into a master
worksheet. I also need it to update simultaneously. So if i add a row in
Sheet 2 and Sheet 1 is the compiled sheet, it automatically reflects what
Sheet 2 looks like?
HELP!!! This seems like it should be so simple and a duh!!! solution but I
just can't figure it out!!!
|