Excel Nebula
New Member
- Joined
- Jun 12, 2003
- Messages
- 3
Hi - I'm new but desperate
I receive on a daily basis a number of data form different places (each with a unique ID). The data is cumulative meaning that a may skip one day and the next day data include all previous dates.
On receiving I copy all the data in one xls file in one sheet (I identify them with the ID and date)
I then append a small database (xl) with all the ID’s new date or dates.
I try to write VBA code to first look in a small database (xl) for ID (unique number) and the date for that ID.
If the date is present the code does not append data for that ID and date to the database –
If the date for that ID is not present it must append the database with that date and ID’s data.
BUT this is above my fireplace and I battle for weeks without success.
Is there someone that can help me with this – O! You’ll make my day, month, and year!!
Thanks in the meantime
NS - I can e-mail you a sample if you like - yust give me the e-mail adress