Photoshop I know inside and out, but Excel is kicking my butt.
Can anybody help me with this scenario?:
I have a spreadsheet that I use for billing statements. One of the columns is called “Billed to Date” (“E”) and the next column is called “Billed this Period” (“F”). Each time I make up a new statement I have to add each value in “F” to the corresponding value in “E”, and enter the new “F” values. There are about thirty values, so it’s a real drag.
What I’d like to do is write a macro that I could run that would A. Do the addition and change the values in “E” and B.Change the values in “F” to 0.00 -ready for this period’s entries.
Any help would be greatly appreciated. I would gladly trade Photoshop knowledge if anyone needs it.