Good day All,
I have a somewhat tricky - for me of course- task to do. I am not sure even if it's at all possible by excel!!!!
I have 50 members each has his/her own workbook. Call them book1 to book50
Then I have 2 separate workbooks lets call them RED and BLUE. I use them as the store for the data of the 50 workbooks.
What I am trying to do.
Say agent1 opens his work book and add a record. And say this record is RED,
The record should be appended to the RED worksheet. If he added a blue record, then that record should go to the BLUE sheet. Verbatim and automatically; no processing of data or anything just same record transferred from agent workbook to the proper RED/BLUE workbook.
RED work book will have all the red records from all agents
BLUE work book will have all the blue records from all agents
An agent’s workbook can have a combination of red and blue.
All sheets have the exact same look and feel and same data types etc...
I am trying to get the 50 workbooks be linked automatically to the RED and BLUE workbooks. i don’t want to do that work manually each week.
Is there a way to that without programming?
Thank you so very much upfront