Using Excel as a Database
Posted by Jim on December 27, 2001 5:24 AM
Not ideal I know - and I guess that's what Access is designed for but here is the situation:
I have a list of unique customer numbers in Sheet 1 column A these I allocate to a debt grouping from a template sheet (i.e. liquidation, write off, active, ceased etc). I then import a report into a different sheet and VLookup the customer allocation. The problem is there are #N/As where customers are new or not listed in the sheet1 list. I need to get the user to run a macro (or another way) to cycle through all the customers with errors and preferably to select an allocation from the list in template sheet. Then copy the new customer and the allocation to the first listing of all customers so as the lookup will update.
Does anybody have a similar spreadsheet set up that I could use as a crib sheet? Failing that I am struggling to get the script right for the dialog allocation listing.
My e-mail is firstname.lastname@example.org
Thanks in advance.