| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Copy an additional row based on another sheet
OK try it in this order:-
If Range("Tuesday!A5") = 1 Then ActiveCell.EntireRow.Copy Sheets(3).Select 'insert this new line Range("TuesdayDateCodes!A6").Select ActiveCell.Offset(1).EntireRow.Insert Application.CutCopyMode = False End If and rename your sheet, taking out the hyphens i.e. TuesdayDateCodes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
| Copy 1 Sheet to Another | Excel Worksheet Functions | |||
| Copy Page Setup from Sheet to Sheet? | Excel Discussion (Misc queries) | |||
| Copy sheet to new workbook | Excel Discussion (Misc queries) | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
Threaded Mode
