What is the best way to continuosly update on workbook with information stored on 13 workbooks with a total of 61 worksheets.
I have inherited someone else's tracking system. They have a seperate workbook for each account that we pay bills out of and a seperate worksheet for each sub account.
Now I am entering the info into the main workbooks and copying and pasting the same info into a combined workbook.
Isn't there a better way. Can I set up the combined worksheet to feed off the exisitng worksheet?
Thanks I am truly baffled on this one.
Rheia
Bookmarks