Hi all,
The setup is as follows: In Sheet1 I have a list of ID's in column A (A2:A10)and in Row 1 (B1:G1) I have list of dates.
In sheet2 I have imported data from a text file where in column A it has some ID's, column B the date that ID was logged and column C the time it was logged. e.g -> In sheet2, cell A1 -> 12345, Cell B1 -> 22/11/05, Cell C1 -> 10:35.
Now the part I'm really stuck! How do I search sheet1 for an ID match and a date match from sheet2 (match for A1 and B1) and where both cells meet in sheet1 insert the third variable.
e.g. If cell A1 from Sheet2 matches cell A3 in Sheet1 and cell B1 matches cell G1 in Sheet1, Insert the time (C1) where both meet , which is G3. And add a loop so that it does this for all the imported data from Sheet2.
Hope this makes sense. I need to search for a match for two variables and insert the third (time) variable where both meet. Like a timetable.
Please, please help! If you want and e-mail of the workbook let me know. I need this ASAP.
Navman
The setup is as follows: In Sheet1 I have a list of ID's in column A (A2:A10)and in Row 1 (B1:G1) I have list of dates.
In sheet2 I have imported data from a text file where in column A it has some ID's, column B the date that ID was logged and column C the time it was logged. e.g -> In sheet2, cell A1 -> 12345, Cell B1 -> 22/11/05, Cell C1 -> 10:35.
Now the part I'm really stuck! How do I search sheet1 for an ID match and a date match from sheet2 (match for A1 and B1) and where both cells meet in sheet1 insert the third variable.
e.g. If cell A1 from Sheet2 matches cell A3 in Sheet1 and cell B1 matches cell G1 in Sheet1, Insert the time (C1) where both meet , which is G3. And add a loop so that it does this for all the imported data from Sheet2.
Hope this makes sense. I need to search for a match for two variables and insert the third (time) variable where both meet. Like a timetable.
Please, please help! If you want and e-mail of the workbook let me know. I need this ASAP.
Navman
