Hello. I'm putting many small records on one large excel spreadsheet and want to generate reports from the same cells of each small record. For example, I want to make a report where the cells for the client's name prints in columns A and B, then the amount owing on their account prints in column C.
Thanks in advance, and I hope my explanation is clear enough.
From what i am understanding from you explanation you are inputting data into a work sheet. Then you need the data to transfer onto another work sheet to create a report.
To do this. reference the cell with the name in column A and B. I.E. If data is in worksheet 1, and your referencing it into Worksheet 2 for a report. then in worksheet 2!A!. hit = (then select the cell in work sheet one where your data is.)
That will reference what is iin that cell for you.