R
RobertM
Hello: I'm trying to write a macro using Tools/Macro/Record New Macro. Here's
the problem. The spreadsheet that I'm working with has information in the
cells in one row of columns A-H. Then in column I there is related info that
will show up for serveral rows. A-H will be blank. This works well if you
look at the spreadsheet, but I need to populate these empty cells with the
related info. I need to have the macro copy the information in the cells in
the row down to populate the empty cells. The macro then needs to stop and
repeat the process when it comes to another row where the cells are populated
with data. I'm trying to get this macro to prepare spreadsheet data for use
in an access database.
This was quite difficult to explain. I hope this makes sense.
Thank you,
Robert
the problem. The spreadsheet that I'm working with has information in the
cells in one row of columns A-H. Then in column I there is related info that
will show up for serveral rows. A-H will be blank. This works well if you
look at the spreadsheet, but I need to populate these empty cells with the
related info. I need to have the macro copy the information in the cells in
the row down to populate the empty cells. The macro then needs to stop and
repeat the process when it comes to another row where the cells are populated
with data. I'm trying to get this macro to prepare spreadsheet data for use
in an access database.
This was quite difficult to explain. I hope this makes sense.
Thank you,
Robert