Hello, need help to create the order sheet, data and image from datasheet to order sheet with v lookup.
the example sheet is attached.
Hello, need help to create the order sheet, data and image from datasheet to order sheet with v lookup.
the example sheet is attached.
VLOOKUP is good, but it isn't that good. This will take some VBA coding. We have to find the image whose top, left corner is closest to the Cell. There are some other things that will also help with this effort starting with making the order sheet into an Excel Table - one thing excel tables do is copy down formulas as data is added so you don't have to.
Here s more information on tables. http://www.utteraccess.com/wiki/Tables_in_Excel.
I'll see what I can do about the rest.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks