I can't seem to figure out how to do this. I have used the HLOOKUP function, but it just doesn't do exactly what I am looking for. I am hoping there is a better way to do this/a macro that can be written.
On the right is prices I have collected from certain websites (not all websites have the product).
On the left is how I would like to organize the data (including all websites).
Ultimately, I would like to delete the collected data on the right and just have the organized data.
Is there any way I can get the prices to automatically move from the right to their matched cell on the left. I can do this manually with copy/cut & pasting (as in rows 2,3) -- but it's very time consuming..
Any help would be much appreciated!!
I am using Excel 2007 and Windows XP. I tried to search the forum for a similar question, but please excuse me of this has been asked already (and a link would be very helpful!).
On the right is prices I have collected from certain websites (not all websites have the product).
On the left is how I would like to organize the data (including all websites).
Ultimately, I would like to delete the collected data on the right and just have the organized data.
Is there any way I can get the prices to automatically move from the right to their matched cell on the left. I can do this manually with copy/cut & pasting (as in rows 2,3) -- but it's very time consuming..
Any help would be much appreciated!!
I am using Excel 2007 and Windows XP. I tried to search the forum for a similar question, but please excuse me of this has been asked already (and a link would be very helpful!).
