Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a new sheet (back log)
the jobs that are in progress are filled with yellow. each time the workbook
is opened, i want it to create a new sheet (overwriting the old one) that fills in all the current jobs (yellow). the difficult part is that a job may be more than one row. each job is seperated by a thick black line. so in the end, it needs to copy over each job (from black line to black line) that is filled in with yellow. also, the rows A2:O6 would need to copied (title and headings) to do it when the document opens, i use: Private Sub Workbook_Open() right? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating tables based on looking down a column and back across a row | Excel Worksheet Functions | |||
Creating tables based on looking down a column and back across a row | Excel Worksheet Functions | |||
Creating a back key | Excel Programming | |||
Creating a monthly back up using Auto_close?? | Excel Programming | |||
4 variables to one sheet, then back to original sheet with answer | Excel Programming |