I need to map one Excel (or could be Access) flat file into another Excel (or Access) file. there are many common fields (cells) but are not arranged in the same order (which is where i get lost)!
I can work in Excel or Access 2007 versions.
is it as simple as copying the source db fields (cells) and then pasting the (copy) field (cell) under the proper location in the destination db? if so, do you have to put inside quotes, etc? suggestions?
i don't care if i have to do it manually but a script / batch would be better of course.
what i am trying to do is import my eBay items into my on-line eStore for more market exposure. i have been trying to do this for 3 weeks now. help!
you can have more than one workbook open at one time.
open the workbooks that you require, then select view/arrange all from the ribbon.
you can have each workbook displayed side by side or one above the other.
it's handy if you have 2 monitors as you can then display one work book on one screen and the other on the other screen.