Basically I recieve a group phone bill that contains a whole heap of data and I need to invoice each of the units individually. Creating the invoice is easy and I can do that, it's just the individual calls being populated in a different sheet on the basis of call type that I need help with.
I would like the data to come up in these sheets from typing a unit number into a separate sheet, and then everything else will populate from this input sheet.
I know I haven't explained the situation very well, so I have attached an example of what im talking about where I have simply copy and paste the data across to the appropriate sheet.
Thanks a lot for your help.
Cheers, Cameron.
Example.xlsx
Bookmarks