| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying and pasting values to the last available column
I need to update daily stautus to the particular column of the
worksheet. Now these values are updated daily in column 22 of worksheet. For today , copy values of acolumn 22 to EA. tomorrow, copy values of column 22 to EB day after , copy values of column 22 to EC and so on regards sanjay |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying and pasting values to the last available column
sanjay,
Is the column EA, Eb, EC... and so on the last used column + 1?? Dennis "sanju" wrote in message ... I need to update daily stautus to the particular column of the worksheet. Now these values are updated daily in column 22 of worksheet. For today , copy values of acolumn 22 to EA. tomorrow, copy values of column 22 to EB day after , copy values of column 22 to EC and so on regards sanjay |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying and pasting values to the last available column
On Mar 18, 1:20*pm, "Dennis Tucker" wrote:
sanjay, Is the column EA, Eb, EC... and so on the last used column + 1?? Dennis "sanju" wrote in message ... I need to update daily stautus to the particular column of the worksheet. Now these values are updated daily in column 22 of worksheet. For today , copy values of acolumn 22 to EA. tomorrow, copy values of column 22 to EB day after , copy values of column 22 to EC and so on regards sanjay- Hide quoted text - - Show quoted text - There are some blank column inbetween which I have kept hidden. So EA onwards will be last visible blank column . In fact I have all my calender mapped from column EA onwards . regards sanjay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for copying and pasting values based on criteria | Excel Programming | |||
| Copying the values in a row to column | Excel Discussion (Misc queries) | |||
| copying a column and pasting as a row... | Excel Discussion (Misc queries) | |||
| Copying other column values when detected | Excel Programming | |||
| Hided values appears when I'm copying/pasting it to other worksheet | Excel Discussion (Misc queries) | |||
![sanju[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
