Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy data and formulas from a column and paste into a row
i have data in one worksheet at the end of a columns that is just totaling
numbers but i need to create a link between this sheet and another that inputs the results into a row i have tried use the transpose button but it does not paste the link and formula. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy data and formulas from a column and paste into a row
Copy/paste the code below into a module. Click on the cell with the first
value in it and run the code: Sub ToRow() With ActiveCell .Resize(1, 9).Copy .Offset(1, 0).PasteSpecial Transpose:=True End With End Sub Notice, this assumes that you have 9 columns of data; change the 9 to whatever number of columns you actually have. Regards, Ryan--- -- RyGuy "john.laffe" wrote: i have data in one worksheet at the end of a columns that is just totaling numbers but i need to create a link between this sheet and another that inputs the results into a row i have tried use the transpose button but it does not paste the link and formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last column, move formulas over, copy/paste data | Excel Worksheet Functions | |||
Copy and paste financial formulas | Excel Worksheet Functions | |||
Copy and paste a formulas | Excel Worksheet Functions | |||
Copy/Paste formulas | Excel Discussion (Misc queries) | |||
copy and paste formulas | Excel Worksheet Functions |