Good Morning,
I have 2 workbooks, the 1st gathers data from my booking app to transfer online bookings, on to the bookings sheet (sheet 1) . Example below (PSB);
(so when a client books in online, this is what auto populates on the Bookings workbook Sheet 1)
These are then arranged in chronological order on sheet 2 of the bookings workbook, PSB
(I have then rearranged the above in to 'day' order, with treatment Bookings workbook Sheet 2)
I have an accounts workbook, that has a separate sheet for each week of the year, PSB
(example of 1 sheet within the Accounts Workbook where there is a separate sheet for every week)
What I would like, is a way that the Accounts workbook auto populates with the data from the Bookings workbook sheet 2.
Currently the only way I can think to do it is by referring every cell on the accounts workbook, to the cells on the bookings work book. I have a whole year to do so this would be very time consuming.
any help would be greatly appreciated!!
I have 2 workbooks, the 1st gathers data from my booking app to transfer online bookings, on to the bookings sheet (sheet 1) . Example below (PSB);
(so when a client books in online, this is what auto populates on the Bookings workbook Sheet 1)
These are then arranged in chronological order on sheet 2 of the bookings workbook, PSB
(I have then rearranged the above in to 'day' order, with treatment Bookings workbook Sheet 2)
I have an accounts workbook, that has a separate sheet for each week of the year, PSB
(example of 1 sheet within the Accounts Workbook where there is a separate sheet for every week)
What I would like, is a way that the Accounts workbook auto populates with the data from the Bookings workbook sheet 2.
Currently the only way I can think to do it is by referring every cell on the accounts workbook, to the cells on the bookings work book. I have a whole year to do so this would be very time consuming.
any help would be greatly appreciated!!