San Antonio Heat
Active Member
- Joined
- Oct 10, 2003
- Messages
- 333
- Office Version
- 2019
- Platform
- Windows
I'm trying to copy from sheet 1 F9 through K9. Once copied it goes to sheet 2 (LIST) and is pasted in the first open spot using the A column as the guide. What I am doing is entering info, clicking a button that runs this macro and it copies and pastes into the LIST page in the next open spot. I think the red text in the code below is where the issue is coming from.
Example of list
' Macro2 Macro
'
'
Range("F9:K9").Select
Selection.Copy
Sheets("LIST").Select
Range("A2").Select
Selection.End(xlDown).Select
Range("A15").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A16").Select
Sheets("Sheet1").Select
Range("L9").Select
End Sub
Example of list
LOG# | RST# | CUSTOMER | TYPE | ADDED | REQUEST |
3284 | 292595 | FORM TECH | MAF STS PANELS (26) STRIP CRNR, RIGID CRNR | 17-Nov | 9-Dec |
3320 | 1717546 | PERI FORMWORKS | IMBEDS (250) 9FT ASSEM, 140K PLASTIC CAPS(500) | 22-Nov | 13-Dec |
' Macro2 Macro
'
'
Range("F9:K9").Select
Selection.Copy
Sheets("LIST").Select
Range("A2").Select
Selection.End(xlDown).Select
Range("A15").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A16").Select
Sheets("Sheet1").Select
Range("L9").Select
End Sub