Hi, I am trying to currently take data from one sheet and transfer this data to other sheets based on set criteria whilst then also still being able to insert additional lines manually as and when required on the final sheets!
On the attached test file the 'Data' sheet would be pulled in from Power Query (it sits on a SP site) and would generally contain a list of in excess of 200 unique numbers each month.
The idea would then be to move the data to other sheets (in this case simply listed as 'U' & 'L' based on the month and the type - again being either U or L and then listed in date order. There would in reality be several columns of data for each unique number.
Finally I would then need to be able to insert additional lines when required without affecting any of the other data and maintaining the list as it stands in date order taken from the original data sheet.
Hope all makes sense,
Thanks,
Gaz
Bookmarks