Results 1 to 3 of 3

Thread: newbie question

  1. #1
    Join Date
    Jun 2012
    Posts
    2

    Unanswered: newbie question

    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.

  2. #2
    Join Date
    Jun 2012
    Posts
    2
    hello. anyone out there?

  3. #3
    Join Date
    Jun 2012
    Posts
    85
    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.

    Mike
    _____________

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •