Posted by Walter on November 17, 2000 6:38 PM
I like to create a Macro in Excel to make some adding up tasks easier. I am new to this and hope it is not too complicated.
I get an excel spreadsheet once a week with items sold. Some of the values have to be added up like local beers and imported beers into one Total. They don't always appear on the same line as items are added and taken off week by week. The Headings like Local Beers or Imported Wines stay the same.
I have an example at: http://www.multiline.com.au/~wje/macro.html
You can see there how it would change from week 1 to week 2.
Thanks for your help