| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
choose a range to copy paste based on data in the cells
Is this possible? I have a column of data (cloumn E) and that the cells
either have a numeric value or text. I need a macro that copies the column only through the numberic values from Column E to Column J. Once the column switches to text I don't want that section of the column copied or pasted. e.g. 900 600 110 115 105 1800 1550 AM EMINI EMINI I only need to copy and paste the column for the range that has numbers, but the range of numeric values can vary even though the numbers will always be first and start at row 1, I never know when the numeric values will end and the text will start. Any help is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
choose a range to copy paste based on data in the cells
Record a macro when you select that original range (Column E).
Then hit ctrl-g (edit|goto in xl2003 menus) hit the Special button check Constants (or Formulas???) uncheck all the subitems, but leave Numbers checked. Copy|paste to the new range. aileen wrote: Is this possible? I have a column of data (cloumn E) and that the cells either have a numeric value or text. I need a macro that copies the column only through the numberic values from Column E to Column J. Once the column switches to text I don't want that section of the column copied or pasted. e.g. 900 600 110 115 105 1800 1550 AM EMINI EMINI I only need to copy and paste the column for the range that has numbers, but the range of numeric values can vary even though the numbers will always be first and start at row 1, I never know when the numeric values will end and the text will start. Any help is greatly appreciated. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
choose a range to copy paste based on data in the cells
Worked perfectly. Thank you!
"Dave Peterson" wrote: Record a macro when you select that original range (Column E). Then hit ctrl-g (edit|goto in xl2003 menus) hit the Special button check Constants (or Formulas???) uncheck all the subitems, but leave Numbers checked. Copy|paste to the new range. aileen wrote: Is this possible? I have a column of data (cloumn E) and that the cells either have a numeric value or text. I need a macro that copies the column only through the numberic values from Column E to Column J. Once the column switches to text I don't want that section of the column copied or pasted. e.g. 900 600 110 115 105 1800 1550 AM EMINI EMINI I only need to copy and paste the column for the range that has numbers, but the range of numeric values can vary even though the numbers will always be first and start at row 1, I never know when the numeric values will end and the text will start. Any help is greatly appreciated. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
| Copy&Paste variable range based on cell value | Excel Programming | |||
| Condition based copy/paste of range | Excel Programming | |||
| Condition based copy/paste of range | Excel Programming | |||
| Condition based copy/paste of range | Excel Programming | |||
Linear Mode
