Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    67

    Unanswered: Access Report to Excel (formatting issue)

    Although this is an excel question, but it is derived from access. I imported a report into excel for updating purposes (long story). Once the report is in excel, there are lot of empty spaces or blanks in the columns. When I finished updating the excel file, and created a link between the report and excel file, I ran the report, but a lot of data are missing due to the blanks.

    I need to repopulate the fields to fill in the blanks (duplicating). I know in excel, there is an expression that is somewhat functions like a ‘iif statement’. For example, in the column ‘customers’, if there is a customer name in the row above, all the empty spaces below will equal or copy that customer name.

    Visual:
    Excel Spreadsheet:

    1. James
    2.
    3.
    4.
    5. Mike
    6.
    7.
    8.
    9.
    10.

    I need to make it so, row 2-4 will have James and 6-10 will have Mike automatically imported.

    I have to apply this expression or criteria throughout the entire worksheet or selected columns.

    Anyone know how to do this?

    Thanks in Advance.

  2. #2
    Join Date
    Mar 2006
    Posts
    163
    I think I've just answered in the Excel forum.

  3. #3
    Join Date
    Nov 2006
    Posts
    67
    Quote Originally Posted by norie
    I think I've just answered in the Excel forum.
    Yes, you have. Thank you very much.

Posting Permissions

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