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 |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com