i need a code that will query one excel spread sheet and transpose the column according to the headers. for example row2 to row 4 row 1 to row 5 etc....
also need query build that say go to .site x
enter and search for item 39523... look on that page and find jpg.... copy the link to jpg to cell A20
and do that on all cells. one that say go to sitex find item number 39523 find height.... etc ...
basically im trying to automate inventory updates for my site.
maybe xml is the solution.
didn't want to limit this but knowledge of interspire would be preferred. you are competing with several other groups outside vworker