postelrich
New Member
- Joined
- Feb 24, 2011
- Messages
- 31
Hi, I have been tasked with updating a database using IBM Reflections for 1600+ entries. I have been doing it by hand so far and have seen threads but never gotten enough info out of them.
What I want to do, which I would do if it were two excel files, is update the database file by using a vlookup to match the customer numbers then fill in the needed fields. I tried to run a macro to see what the code looks like but I don't see how to look up the entry by the cust name and amend the other parts.
Please help! I know I am more or less asking for the whole code but repititive tasks and not being able to figure out the easy way make the OP go crazy.
What I want to do, which I would do if it were two excel files, is update the database file by using a vlookup to match the customer numbers then fill in the needed fields. I tried to run a macro to see what the code looks like but I don't see how to look up the entry by the cust name and amend the other parts.
Please help! I know I am more or less asking for the whole code but repititive tasks and not being able to figure out the easy way make the OP go crazy.
