Hi,
I am not very good with excel hence the post. I am trying to transfer data from one workbook to another (without copying and pasting it) using some sort of V-look up formula or any other that I may not be aware of. I have given an example of the data set below:
Workbook1:
<tbody>
</tbody>
Workbook2:
<tbody>
</tbody>
In Workbook2 from cell B2 to B5 I would like to use a formula to pick up the yes or no from Workbook1. I dont want to copy and paste the results over as this is just an example but the work I will be doing contains thousands of data entries being updated at various times.
Alternatively, if there is a better way of doing this, please do let me know.
This is my first post, so apologies in advance if I have not followed the correct protocol or etiquette of posting a thread.
Thank you for your help.
UR
I am not very good with excel hence the post. I am trying to transfer data from one workbook to another (without copying and pasting it) using some sort of V-look up formula or any other that I may not be aware of. I have given an example of the data set below:
Workbook1:
A | B | |
1 | Reference Number | Fixed |
2 | 39217 | Yes |
3 | 17390 | No |
4 | 19283 | No |
5 | 18304 | Yes |
<tbody>
</tbody>
Workbook2:
A | B | |
1 | Reference Number | Fixed |
2 | 39217 | ? |
3 | 17390 | ? |
4 | 19283 | ? |
5 | 18304 | ? |
<tbody>
</tbody>
In Workbook2 from cell B2 to B5 I would like to use a formula to pick up the yes or no from Workbook1. I dont want to copy and paste the results over as this is just an example but the work I will be doing contains thousands of data entries being updated at various times.
Alternatively, if there is a better way of doing this, please do let me know.
This is my first post, so apologies in advance if I have not followed the correct protocol or etiquette of posting a thread.
Thank you for your help.
UR
Last edited: