Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a macro to paste into first empty row in a new worksheet
Using a macro within a workbook, I am wishing to paste information from other
worksheets into an existing work sheet which already contains rows of data. The macro should be able to determine the first empty row and then paste. I cannot determine which function to use and how? -- Bruce |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a macro to paste into first empty row in a new worksheet
Sub lookit()
Set s1 = Sheets("Sheet1") Set s2 = Sheets("Sheet2") Set r1 = Selection For i = 1 To Rows.Count If Application.CountA(s2.Rows(i)) = 0 Then r1.Copy s2.Cells(i, "A") Exit Sub End If Next End Sub Select the material you want to copy on Sheet1; the macro sill copy it to the first blank row in Sheet2 -- Gary''s Student - gsnu200758 "Bruce64" wrote: Using a macro within a workbook, I am wishing to paste information from other worksheets into an existing work sheet which already contains rows of data. The macro should be able to determine the first empty row and then paste. I cannot determine which function to use and how? -- Bruce |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a macro to paste into first empty row in a new worksheet
See also
http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bruce64" wrote in message ... Using a macro within a workbook, I am wishing to paste information from other worksheets into an existing work sheet which already contains rows of data. The macro should be able to determine the first empty row and then paste. I cannot determine which function to use and how? -- Bruce |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a macro to paste into first empty row in a new worksheet
This is very close to what I'm looking for EXCEPT
I want it to paste the validation edits ONLY. Theo "Gary''s Student" wrote: Sub lookit() Set s1 = Sheets("Sheet1") Set s2 = Sheets("Sheet2") Set r1 = Selection For i = 1 To Rows.Count If Application.CountA(s2.Rows(i)) = 0 Then r1.Copy s2.Cells(i, "A") Exit Sub End If Next End Sub Select the material you want to copy on Sheet1; the macro sill copy it to the first blank row in Sheet2 -- Gary''s Student - gsnu200758 "Bruce64" wrote: Using a macro within a workbook, I am wishing to paste information from other worksheets into an existing work sheet which already contains rows of data. The macro should be able to determine the first empty row and then paste. I cannot determine which function to use and how? -- Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On a DDE Linked worksheet : Copy and Paste Value to a to a file via a macro ? | Links and Linking in Excel | |||
macro- move down to empty cell & active worksheet | Excel Worksheet Functions | |||
cannot cut & paste because clipboard is empty | New Users to Excel | |||
Macro copy and paste = blank worksheet | Excel Discussion (Misc queries) | |||
Cannat paste that macro formula onto a worksheet | Excel Discussion (Misc queries) |