Search results

Here's an example Excel. The third column had a formula looking for "Duplicate" next to it, and left the cell empty if Duplicate was there, so you could manually add a version number. Later you could copy that column and paste the values to remove all formulas. The formula is really only needed...

It may be easier to put it back into excel, make a new column next to the one with the numbers, sort the numbers column so the like items are next to each other, and have a simple formula return something when the cell next to it is equal to the cell below it. If you only have items that may...

It may be simple enough to do with a macro. being new to this board though, I am not sure how liked the use of Macros are :) Good luck

I think the short answer is Yes, and many possible ways. I think the easiest way would be to initiate the transfer of data from the destination DB. You could probably write some code to simply Import the tables from the source and appending it to the existing table on the destination. Or, you...