| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPY DATA CELL TO CELL
I have a problem, I need a macro to do for me, I hope. I tried posting this
question once already, but I do not see it in the discussion list so we'll try again. I export data out from one program in to another, this is what it looks like. Before I copy and paste... A B Row1 S201 854-12 Row2 999-99 Row3 600-00 Row4 700-00 Row5 S205 1234-5 Row6 333-22 Row7 888-22 ----------------------------------------------------------------------------------------- This is what it looks like after I finish with the copy and paste. A B Row1 S201 854-12 Row2 S201 999-99 Row3 S201 600-00 Row4 S201 700-00 Row5 S205 1234-5 Row6 S205 333-22 Row7 S205 888-22 Is there a Macro that can do this for me? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COPY DATA CELL TO CELL
A macro is not needed. Pick an un-used column, say C. In C1 enter:
=A1 in C2 enter: =IF(A2="",C1,A2) and copy down Copy column C and paste/special as value back into column A -- Gary's Student "Sean" wrote: I have a problem, I need a macro to do for me, I hope. I tried posting this question once already, but I do not see it in the discussion list so we'll try again. I export data out from one program in to another, this is what it looks like. Before I copy and paste... A B Row1 S201 854-12 Row2 999-99 Row3 600-00 Row4 700-00 Row5 S205 1234-5 Row6 333-22 Row7 888-22 ----------------------------------------------------------------------------------------- This is what it looks like after I finish with the copy and paste. A B Row1 S201 854-12 Row2 S201 999-99 Row3 S201 600-00 Row4 S201 700-00 Row5 S205 1234-5 Row6 S205 333-22 Row7 S205 888-22 Is there a Macro that can do this for me? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy last cell with data in column E on one sheet to cell on anoth | Excel Worksheet Functions | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| macro to copy & paste cell data into another cell | Excel Programming | |||
| Writing a macro to copy first cell down until next cell has data | Excel Programming | |||
![Sean[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
