Hey there,
I am new to this forum and looking to get some help in solving my issues & building mu excel skills.
I have a macro code thats pulling conditional data from my main worksheet to new worksheets and than formatting that data.
I need a new macro that should ;
1.
Insert a new row with word "Personal Total" in column A ,2 rows above the word "Private" . ex if Private appears a A8 , PERS. SUM shud be A6 , if Private is A34 PERS. SUM shud be A32..
Check : - If "PERS. SUM" already exists , no action should be take i.e. code should not over write it.
2.
Insert a new row with word "PVT. SUM" should in column A , exactly above word "GRAND TOTAL" which is also in column A. So if "GRAND Total" is in A14 , PVT. SUM shud be in A14 like this.
Check : - If "PVT. SUM" already exists , no action should be take i.e. code should not over write it.
3.
Macro should this for all worksheets in available workbook except a work sheets "Final" & "Mid-Year" .
Both words "PERS.SUM" or "PVT.SUM " , if coming from this macro should have cell colour as grey and it should also grey corresponding columns in row B,C,D,E. i.e. macro does not finds "PERS. SUM " , and it putting this word in A8 than B8,C8,D8,E8 cells should be of grey colour ..same for "PVT. SUM" .
Let me know if this makes any sense.
Thank you for taking your time to read this.
Byess,
Tanya
Bookmarks