I have one spreadsheet that i have to take data from another and apply to it. Is there a way to make it do auto using criteria such as: Sheet 1 (where the data is going) looks at sheet 2 and uses criteria such as, looking at 1 column to get part of the data and then a 2nd column to get what is acutally being put on sheet 1?
2007-08-30 10:52:55 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
Yeah you can definitely do that with certain Excel formulas. Just when you specify the range, specify it with sheet name and an exclamation point.
For instance, to reference cell A1 on Sheet2 in Sheet1 you'd enter:
=Sheet2!A1
If the worksheet has any spaces in the name you have to surround the name with apostrophes like so;
='Sheet 2'!A1
I can't really tell you more than that without you being more specific in what you are wanting to do. There are so many Excel formulas. And depending on exactly what you are wanting to do the formula to do it will be different.
2007-08-31 00:58:16 · answer #1 · answered by devilishblueyes 7 · 0⤊ 0⤋
Sounds like you are wanting to do a V-lookup or similar feature. I'm not sure exactly what you're trying to do but it may also be easier to combine the data in columns 1 and 2 into a separate column and then use the v lookup or index matching to pull from the newly combined column. That would be a simple way to migrate the data, then you could split it out. Unfortunately, there's no way to look at what you're trying to do in order to fully comprehend it but it probably wouldn't be too difficult with the formulas mentioned above.
2007-08-30 18:47:52 · answer #2 · answered by Stumpy 4 · 0⤊ 0⤋
You need to highlight what you are going to copy, then select "Edit" and then "Paste Special". If it doesn't copy if exactly you may have to adjust the cell size but that is normal. Good luck!
2007-08-30 18:06:55 · answer #3 · answered by Brain 4 · 0⤊ 0⤋