I used to use Actools all the time for the games that I played. I am now looking for a macro for my Professional life. I need a Macro to Update pricing from one colum of prices and discounting them and putting the new price in a seperate colum. I am not very good at writing macros so any help would be appreciated.

Thanks

If you're using a spreadsheet program, then there are built in compute functions...

You just need to use the = at the beginning of the cell to tell Excel to treat it as a formula.

Example below should give 20% discount, put this in C2 column.

= B2 - (B2 * 0.2)

There's ways to copy formulas down too, I'd suggest reading the help on whatever program your using.

I have myself used macros for scripting spreadsheets for certain things that it just was not able to do (probably could using VBScript..but I don't know it).

If you wanted to use AcTool, I would highly recommend exporting the data to a regular text file, then ListLoading in and processing it and putting out the output in a separate file.


You can copy and paste information to the clipboard from excel and paste right into notepad the data.
ListLoad, ListSave, and compute should be about all you need. You should know the rest if you've used AcTool before.