Beddy Boy
New member
- Joined
- Feb 1, 2017
- Messages
- 48
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365
Hi,
I wonder if anyone can help me? I have multple rows of data that have to be inputted into another similar worksheet. It would take me years to simply copy and paste. I would like a quicker way if anyone can help??
One sheet contains :
101478951 FINE GOOD 1000
101478953 SOFT GOOD 1200
ETC. ETC. for thousands of entries.
Then on a separate sheet I have
101478951 SMITH L
101478951 JONES L
101478951 GARY W
101478953 JOHN L
101478953 WAYNE L
ETC. ETC.
Now what i need to do is somehow import the data from the first sheet into the second so it looks something like:
101478951 FINE GOOD 1000 SMITH L
101478951 FINE GOOD 1000 JONES L
101478951 FINE GOOD 1000 GARY W
101478953 SOFT GOOD 1200 JOHN L
101478953 SOFT GOOD 1200 WAYNE L
Any help would be greatly appreciated!
I wonder if anyone can help me? I have multple rows of data that have to be inputted into another similar worksheet. It would take me years to simply copy and paste. I would like a quicker way if anyone can help??
One sheet contains :
101478951 FINE GOOD 1000
101478953 SOFT GOOD 1200
ETC. ETC. for thousands of entries.
Then on a separate sheet I have
101478951 SMITH L
101478951 JONES L
101478951 GARY W
101478953 JOHN L
101478953 WAYNE L
ETC. ETC.
Now what i need to do is somehow import the data from the first sheet into the second so it looks something like:
101478951 FINE GOOD 1000 SMITH L
101478951 FINE GOOD 1000 JONES L
101478951 FINE GOOD 1000 GARY W
101478953 SOFT GOOD 1200 JOHN L
101478953 SOFT GOOD 1200 WAYNE L
Any help would be greatly appreciated!