Hi,
I've two table on is a source and the other on is a destination id the data I want to display.
All what i need is a macro to update the current IDs and get the new IDs from the source to destination
Thanks alot
Hi,
I've two table on is a source and the other on is a destination id the data I want to display.
All what i need is a macro to update the current IDs and get the new IDs from the source to destination
Thanks alot
Try the attached.
Last edited by AB33; 01-05-2014 at 05:31 PM.
thanks alot for the quick response.
I have a problem with the code in the attached sheet. in this Line
I dont want to remove contents specially from column A and E.Please Login or Register to view this content.
I just to need to update the linked data to each ID in the destination table and copy the new rows only.
because In this code the data linked in column E to each ID bcomes not matching and not accurate after running the macro
Thanks again
mido609,
I think this will solve your problem.
I have included the last code I wrote to with the attached. I hae removed it and the code should work with sheet1
The code works on ID match. If the match does not exist, it copies that row.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks