| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - move active cell to another column; same row | Excel Programming | |||
| Filter Macro that can work for any column/active cell | Excel Programming | |||
| Macro with input box to Select a column on active sheet | Excel Programming | |||
| pasting textbox value to active cell | Excel Discussion (Misc queries) | |||
| how do find out the column of the active cell in a macro? | Excel Programming | |||
Hybrid Mode
