Excel Macro for pricing
Budget: $30 – $250 AUD
We need an Excel Macro made to do the following.
It should have a button to run the macro.
MACRO #1 1.
1. On Variables tab there is two columns "Change this" "To This" F/G, we need to do a find and replace on all tabs so for example the first one Change S9 Edge+ to S9+ on all tabs, keep going until it has done all the ones on column F.
The following should be repeated for each tab at the bottom except Variables
1. Delete any images
2. Delete row 1,2,3,4&5
3. If you go down the rows you will find one which says "1) Bank Info: ", delete this row and every row beneath it (note this will be on a different row each time depending how many results there are.
4. If column A/B do not contain the words SUB TOTAL and column C contains any QTY(Not nil) then multiply the value in column D by this sum
E.G
D47/Variables!B2*Variables!B4
Put the output into column F (I have done the first one as an example)
Then copy the end value back into column D for this example it should be 137.92
5. Continue doing this until the full sheet is done
6.Then Delete column F
7. Filter column C by any QTY (not NIL or blank)
8. Copy the contents of the filtered results and paste them onto a brand new spreadsheet
9. Add a Row at top (row 1) = Height 70 pixels
10. Add the attached image to row 1
11. Name the new spreadsheet the exact name of the tab it was copied from eg for this example it would be P1.
>>>This process should repeat for every tab at the bottom.
It should have a button to run the macro.
MACRO #1 1.
1. On Variables tab there is two columns "Change this" "To This" F/G, we need to do a find and replace on all tabs so for example the first one Change S9 Edge+ to S9+ on all tabs, keep going until it has done all the ones on column F.
The following should be repeated for each tab at the bottom except Variables
1. Delete any images
2. Delete row 1,2,3,4&5
3. If you go down the rows you will find one which says "1) Bank Info: ", delete this row and every row beneath it (note this will be on a different row each time depending how many results there are.
4. If column A/B do not contain the words SUB TOTAL and column C contains any QTY(Not nil) then multiply the value in column D by this sum
E.G
D47/Variables!B2*Variables!B4
Put the output into column F (I have done the first one as an example)
Then copy the end value back into column D for this example it should be 137.92
5. Continue doing this until the full sheet is done
6.Then Delete column F
7. Filter column C by any QTY (not NIL or blank)
8. Copy the contents of the filtered results and paste them onto a brand new spreadsheet
9. Add a Row at top (row 1) = Height 70 pixels
10. Add the attached image to row 1
11. Name the new spreadsheet the exact name of the tab it was copied from eg for this example it would be P1.
>>>This process should repeat for every tab at the bottom.