Hi all,

I am trying to write a macro that opens a spreadsheet and copies certain information to another spreadsheet. However its a little more complex in that I would like my macro to copy certain cells based on what I have in my second spreadsheet. For example, I would like to copy the value of the cell next to the cell labeled 'number of orders' & paste it into the cell next to the cell that says 'number of orders' in my second spreadsheet. I would like to do this for about 80 items.

Thanks in advance