| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
What Excel macro puts data in the NEXT row of a sheet?
I have a list of data in col B of sheet 2 which I need to copy and transpose
into sheet 1, then delete the data in sheet 2 to use the form again to copy and transpose onto the next line in sheet 1. I have tried with a macro shortcut I've called ctrl + e. (I am really using the data form process but cannot because I have too many inputs). Is there a simple macro I can copy and paste? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
What Excel macro puts data in the NEXT row of a sheet?
Where does sheet2 Col B get its data from? Wouldn't it be easier to copy
from the source? If you give more info, I am sure soemone here can help you! -- Hth Kassie Kasselman "KenC" wrote: I have a list of data in col B of sheet 2 which I need to copy and transpose into sheet 1, then delete the data in sheet 2 to use the form again to copy and transpose onto the next line in sheet 1. I have tried with a macro shortcut I've called ctrl + e. (I am really using the data form process but cannot because I have too many inputs). Is there a simple macro I can copy and paste? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change data in a sheet | Excel Discussion (Misc queries) | |||
| Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
| Importing Data | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Linear Mode
