I have a data Worksheet that holds invoice details based on a 'Code' in column A (see attached sample).
Each code then has its own tab in the Workbook. I'm trying to find a way to extract the invoice information from the 'Data' tab that relates to each 'Code' so it appears on the associated tab based on the code entry in cell C3.
I've completed the expected outcome for tabs AB123, AB124 and AB127 and provided the criteria on the Data tab. The idea being that when a 'Code' is entered in cell C3, it extracts the relevant date from the data tab as per the sample worksheets.
I have no idea if this is possible to achieve using formula or code but would welcome any help trying to find a solution. Please let me know if anything doesn't make sense.
Many thanks
Bookmarks