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.
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.