How to transfer lines of txt from one sheet to another sheet?
Solved/Closed
Related:
- How to transfer lines of txt from one sheet to another sheet?
- Free fire transfer - Guide
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Little alchemy cheat sheet - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 16, 2015 at 12:08 PM
Feb 16, 2015 at 12:08 PM
Hi Mike,
Let me see if I get what you are trying to do:
Once a day you want to check the 10 values from sheet 2 (A2:A11?) and look them up on sheet 1 (column A?). This will result in 10 rows of data from sheet 1, that you want to copy to sheet 3. The next day you want to add another 10 rows to the existing ones and so on ....
Providing your file, without sensitive information, is always handy to see if there is anything that might ruin an otherwise good solution.
Best regards,
Trowa
Let me see if I get what you are trying to do:
Once a day you want to check the 10 values from sheet 2 (A2:A11?) and look them up on sheet 1 (column A?). This will result in 10 rows of data from sheet 1, that you want to copy to sheet 3. The next day you want to add another 10 rows to the existing ones and so on ....
Providing your file, without sensitive information, is always handy to see if there is anything that might ruin an otherwise good solution.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 23, 2015 at 11:43 AM
Feb 23, 2015 at 11:43 AM
Hi Mike,
The easiest way would be to use the VLOOKUP formula. But for that the search value (Team) should be in the left most column.
In your file below I have switched column A and B of Sheet 1 and entered the VLOOKUP formula in Sheet 3.
http://ge.tt/1vKrA1B2/v/0?c
See if you can work with the result, otherwise you will have to ask me kindly to write a code for you ;).
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
The easiest way would be to use the VLOOKUP formula. But for that the search value (Team) should be in the left most column.
In your file below I have switched column A and B of Sheet 1 and entered the VLOOKUP formula in Sheet 3.
http://ge.tt/1vKrA1B2/v/0?c
See if you can work with the result, otherwise you will have to ask me kindly to write a code for you ;).
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Feb 17, 2015 at 12:18 PM
http://www.speedyshare.com/CrJEg/For-Excel-Helper-Game-Plan.xlsx
If you could work into this excel and provide me with a workable version back that would be amazing. Below is a live example of what I need.
Live Example:
This is for basketball games. Sheet two has information of what teams are playing who. For example in first game Towson & Drexel (Cell C1 & C2) are playing each other. In Sheet 1 there stats of each team (Towson & Drexel and many others). Information on both sheets will change everyday, but the formatting will stay the same so we need to create a logical formula to say the following:
The Formula should start in Sheet3-B3
"When Sheet 2 C1 (in this case Towson) lines up with any name between Sheet 1 B1 though B367 (In this case Towson is Sheet1255) THEN Copy and paste that entire line (in this case Sheet1 A255-Sheet1 U255) into Sheet3 starting in cell B3.
In Sheet 3 - I went ahead and copy and pasted what I want the final result to look like. Now I want this to do it over and over again until sheet 2 runs out of games.
Does this make sense?
Feb 19, 2015 at 11:37 AM
Yes that makes sense, I just found a double entry in C47 of Sheet2 (Wisconsin Milwaukee). Is that a mistake or is it something that can happen? and if so, then how would you like to handle it.
Best regards,
Trowa
Feb 19, 2015 at 01:14 PM
That is actually a team name (Two words in one). This may happen from time to time where the team name in sheet two will not line up with sheet 1 exactly. In this example for Sheet 2 C47 Wisconisin Milwaukee is just Milwaukee in Sheet1 241. In this case just program it to look for Wisconisin Milwaukee and I will have to manually change it in Sheet 1. Thank you so much for your help!
PS - this will also happen for things like: Colorado State will be Colorado St. in sheet 1.
I hope this makes sense. Thank you again!
-Mike