I’ve attached an example of some code (compliments of Hans, but I’ve adapted it to my newest project) and I’d like to add to it… any help is appreciated as usual… below is what I’d like to acheive:
When column G from the “database” worksheet is copied to the “new” worksheet I’d like to have it multiplied by -1.
I’ve left 4 empty spaces after each movement because I’d like the empty rows underneath to be “filled in” with the orignal data that was moved over to the “new” worksheet, however I’d like the first empty space in Column A to add the letters “AP” onto what is in the cell above it (cell A5 has 75PVAL in it, so I’d like cell A6 say 75PVALAP”). I’d like the 2nd empty space to add the letters “NA”, the 3rd empty space to add the letters “SA”, and the 4th empty space to add the letters “EU”. I’d like the account number in column B to simply copy down and fill in the 4 empty spaces below it, as there is no need to “add” anything to it.
The very last step, after all steps above are done, I’d like to multiply the dollar amount that was transferred over by the % in column D (the % will be there due to a vlookup formula), and rounding 2 places.
As usual, I appreciate the help! Getting help with the code from this website is helping me learn how to do it myself!
Thanks,
Lana