SuchHelp_MuchThanks
New Member
- Joined
- Jan 7, 2014
- Messages
- 16
Hey,
Just want to say, this is a great community as I've constantly been coming here to read other people advice but I finally have a question for myself!
Please bare with me as I'm not too sure on the best way to get this into words. I'm currently creating a brand new fancy spreadsheet but using data from an old one. I've moved across all the raw data into a different sheet into the new work book but all the information is everywhere. Is there an equation to automatically import data with matching names for example? I want to bring emails and addresses from the raw data and have it automatically put in the new spreadsheet matching the names. One is in alphabetical order and the other is in order of order date. So I can't just copy and paste. I currently have to do it one by one which will take me a very long time. Is there a way to bring over John Bloggs email and address and have it paste in each of John Bloggs orders automatically?
Sorry if this is a little convoluted!
Thanks
Just want to say, this is a great community as I've constantly been coming here to read other people advice but I finally have a question for myself!
Please bare with me as I'm not too sure on the best way to get this into words. I'm currently creating a brand new fancy spreadsheet but using data from an old one. I've moved across all the raw data into a different sheet into the new work book but all the information is everywhere. Is there an equation to automatically import data with matching names for example? I want to bring emails and addresses from the raw data and have it automatically put in the new spreadsheet matching the names. One is in alphabetical order and the other is in order of order date. So I can't just copy and paste. I currently have to do it one by one which will take me a very long time. Is there a way to bring over John Bloggs email and address and have it paste in each of John Bloggs orders automatically?
Sorry if this is a little convoluted!
Thanks