M
mstorkamp
Hi,
I'm relatively new to macro programming with excel, and I'm having
trouble dealing with variable length data. Every week I get a
spreadsheet that has data in columns A through J, and rows 1 through
somewhere around 3000 plus or minus a hundred or so, and 3 sheets. I
need to take the data from sheets 2 and 3 and append them to the
bottom of sheet 1, as well as put a formula into column K and copy it
down to the end of the data. When I tried to record a macro doing
this, it always saves a cell address for the last row in this
particular spreadsheet, so it won't work on next weeks because there
will be a different number of rows.
Is there an easy way to fill column K down to the same number of
rows for which there is data in column A?
I'm relatively new to macro programming with excel, and I'm having
trouble dealing with variable length data. Every week I get a
spreadsheet that has data in columns A through J, and rows 1 through
somewhere around 3000 plus or minus a hundred or so, and 3 sheets. I
need to take the data from sheets 2 and 3 and append them to the
bottom of sheet 1, as well as put a formula into column K and copy it
down to the end of the data. When I tried to record a macro doing
this, it always saves a cell address for the last row in this
particular spreadsheet, so it won't work on next weeks because there
will be a different number of rows.
Is there an easy way to fill column K down to the same number of
rows for which there is data in column A?