Hi,
I’m hoping that someone can help me out, as I’m somewhat stumped and realistically I’m still new to excel when it comes to anything more than your average spreadsheet.
Basically I have a spreadsheet with 2 tabs, one with outstanding jobs listed on it, and another with completed jobs.
I have successfully (with Google’s help!) Andes some code so when I add a date into the job completion date cell for any given row it completely removes the row and inserts it into the next available row on my completed jobs tab.
This was great and I was extremely chuffed... but I had also added continual formatting so that if a job was a quote certain cells on the row would fill in black to indicate nothing was required within them, and if the job was actual work they would highlight as red until filled with the required text.
This also worked a treat until the job was completed and it moved the row to the other tab.
The reason for this would be if the conditional formatting for row 5 looked at cell A5 to see if it said “Quote” and if it did the cells in question went black. But as soon as this moved to the other tab as a completed job it was still looking at A5 on the first tab which then messes up my second tab.
Is there a way to do what I need (apologies if I’ve not explained this very well) so that my formatting travels with the row to the new tab?
Thanks in advance,
Shawn
I’m hoping that someone can help me out, as I’m somewhat stumped and realistically I’m still new to excel when it comes to anything more than your average spreadsheet.
Basically I have a spreadsheet with 2 tabs, one with outstanding jobs listed on it, and another with completed jobs.
I have successfully (with Google’s help!) Andes some code so when I add a date into the job completion date cell for any given row it completely removes the row and inserts it into the next available row on my completed jobs tab.
This was great and I was extremely chuffed... but I had also added continual formatting so that if a job was a quote certain cells on the row would fill in black to indicate nothing was required within them, and if the job was actual work they would highlight as red until filled with the required text.
This also worked a treat until the job was completed and it moved the row to the other tab.
The reason for this would be if the conditional formatting for row 5 looked at cell A5 to see if it said “Quote” and if it did the cells in question went black. But as soon as this moved to the other tab as a completed job it was still looking at A5 on the first tab which then messes up my second tab.
Is there a way to do what I need (apologies if I’ve not explained this very well) so that my formatting travels with the row to the new tab?
Thanks in advance,
Shawn
