Hello everyone. I hope I posted this in the correct forum. Here is my dilemma. I am trying to merge information from two spreadsheets to another for a report for my boss. Basically, what I want to do is as follows: If there is data in cell R2 of the first spreadsheet, I want to take information from cell B2 of the same spreadsheet and populate cell B2 of the new spreadsheet. If I get this formula right, then I can alter it to fit the other cells for the other information I need to include.
Here is my formula so far:
=IF('Q:\SHR\InfoShare\Die Shop\Planning\[DIE INVENTORY]CURRENT'!R2)=('Q:\SHR\InfoShare\Die Shop\Planning\[DIE INVENTORY]CURRENT’!)DATA
The information in the first spreadsheet resides on Q drive, the path to the workbook is listed, the workbook (DIE INVENTORY) and the worksheet name (CURRENT). I think the formula is right to that point, it’s at this point that it breaks down.
Can anyone help?
Bookmarks