Macro for pasting on active column
 

Hello,

I receive a daily report in Excel and I need to copy the information from a
range of cells and paste it into an Excel database (a different file from the
report).

I was thinking that I could make a macro that copies the info from the daily
report (it's always the same range of cells) and then pastes it in the column
that's active.

Daily Report File: Copy (C1:C3)

Database File: Paste in the Active Cell so that the information from the
daily report will be added each time in a new column.

(If you have a better method, I'm all ears)

Thanks in advance.

Macro for pasting on active column
 

If it does not matter that the active column might contain dara, I suppose it
would be OK. Otherwise you might want to check to see if it contains cata
and then find the next column that does not.

"igorin" wrote:

Hello,

I receive a daily report in Excel and I need to copy the information from a
range of cells and paste it into an Excel database (a different file from the
report).

I was thinking that I could make a macro that copies the info from the daily
report (it's always the same range of cells) and then pastes it in the column
that's active.

Daily Report File: Copy (C1:C3)

Database File: Paste in the Active Cell so that the information from the
daily report will be added each time in a new column.

(If you have a better method, I'm all ears)

Thanks in advance.

Macro for pasting on active column
 

JLG:

But how do I write the macro to get it to past in the active cell?

Thanks in advance!!!

:-)

"JLGWhiz" wrote:

If it does not matter that the active column might contain dara, I suppose it
would be OK. Otherwise you might want to check to see if it contains cata
and then find the next column that does not.

"igorin" wrote:

Hello,

I receive a daily report in Excel and I need to copy the information from a
range of cells and paste it into an Excel database (a different file from the
report).

I was thinking that I could make a macro that copies the info from the daily
report (it's always the same range of cells) and then pastes it in the column
that's active.

Daily Report File: Copy (C1:C3)

Database File: Paste in the Active Cell so that the information from the
daily report will be added each time in a new column.

(If you have a better method, I'm all ears)

Thanks in advance.