Is there a way in Excel to take a spreadsheet containing new price
adjustments, compare it to my current inventory, make price changes as
necessary on my current inventory spreadsheet, and , then print a list of
changed items? Or is this an Acess function?
Thanks,
Gary B
gb20003@comcast.net
Bob Flanagan - 19 Jun 2007 03:09 GMT
Gary, take a look at the Data Loader at http://www.add-ins.com/dataload.htm.
It will do most of what you want. It will color the cells that are loaded
blue so that you can identify the ones that were updated.
Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707
Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
> Is there a way in Excel to take a spreadsheet containing new price
> adjustments, compare it to my current inventory, make price changes as
[quoted text clipped - 4 lines]
> Gary B
> gb20003@comcast.net