sjo007
New member
- Joined
- Dec 1, 2015
- Messages
- 28
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel for Mac 16.4
I have 2 sheets. The first column in both sheet A and Sheet B have the same ID no in that column.
If there is an entry greater than 0 in Sheet 1 Column B (called Data A), then copy that entry to Sheet 2 Column B (Data B) against the correct ID in that Row.
What formulae do I need to put in Sheet 2 Column B (data B) in order to pull this data from Sheet 1 please ?
The reason behind this is that I have many Sheet 1s that do not have rows with consecutive row number on so I am copying data by hand from the ID no on on Sheet 1 to the corresponding ID no on Sheet 2.
So the formula needs to look at the ID no on Sheet 1 and if there is a value in that row greater than 0 (Data A) , then copy that number to the correct row on Sheet 2 - which I hope makes sense.
Any help with this would be much appreciated. Please see Sample file attached.
Best wishes,
Stephen
If there is an entry greater than 0 in Sheet 1 Column B (called Data A), then copy that entry to Sheet 2 Column B (Data B) against the correct ID in that Row.
What formulae do I need to put in Sheet 2 Column B (data B) in order to pull this data from Sheet 1 please ?
The reason behind this is that I have many Sheet 1s that do not have rows with consecutive row number on so I am copying data by hand from the ID no on on Sheet 1 to the corresponding ID no on Sheet 2.
So the formula needs to look at the ID no on Sheet 1 and if there is a value in that row greater than 0 (Data A) , then copy that number to the correct row on Sheet 2 - which I hope makes sense.
Any help with this would be much appreciated. Please see Sample file attached.
Best wishes,
Stephen