Hey everybody,
I'm looking for a macro code to accomplish multiple tasks so that we can save time.
This is how the chart looks like at first glance: test1.xlsx
There are 5 steps that I would like to do:
A) In the above attachment I would like to have cells "D18" & "E18", which each have a formula entered into them, copied as values into each cell going down columns "D" & "E" like this : test2.xlsx
B) Then I would like to delete any row in column "C" that has a "0" or a "" (blank) in them so it would look like this: test3.xlsx *please note that any blanks above row 17 is not counted for the deletion code.
C) Next I would like to automatically add, underneath the last cells that have data in them, a border surrounding cells A,B,C,D & E as shown here: test4.xlsx and that it should be filled in with a light grey color as shown, with the text "Total" on column "B", the sum total on column "C", the text "Total Cost" on column "D" and the sum total on column "E". And please keep all texts centered vertically and horizontally and in bold (WHEW! Hope this isn't too confusing )
D) The last thing I need is to have the print area to be set underneath the last row that has data in them. So in this attachment: test5.xlsx I would like to have up until the last line with data in it to be included in the print.
I hope this is possible and if anyone can create this code please let me know as this would be a great help.
Thank you :-)
Bookmarks