Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2014, 09:12 PM
rogcar75 rogcar75 is offline Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Windows 7 64bit Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Office 2010 32bit
Novice
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions.
 
Join Date: Aug 2014
Location: OU Country
Posts: 15
rogcar75 is on a distinguished road
Default Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions.

Ok here is what I want to do, if anyone can help:



On sheet 1 I have a player universe.
On sheet 2 I have 2 tables setup
1 for position players
1 for pitchers.

I am wanting to take the info from rows 5 and 8 to the position players table, thru Column I.
Also would like the rows of info from sheet 1 to be placed on starting row 4, then the next players info placed on row 5.
(And the condition would be if that position player is owned by a certain owner in column J, the examples i have used for this test is rog in column J as a owner for these 2 position players.)


I am wanting to take the info from rows 7 and 11 to the Pitchers table, thru Column I.
Also would like the rows of info from sheet 1 to be placed on starting row 4, then the next players info placed on row 5.
(And the condition would be if that pitcher player is owned by a certain owner in column J, the examples i have used for this test is rog in column J as a owner for these 2 pitcher players.)

I am pretty sure this can be done, but I evidently don't have the smarts to do it, any help is greatly appreciated, on the formula to do these actions.
Thanks Rog.
Attached Files
File Type: xlsm Testformulaforsheet2pitcherposition.xlsm (323.4 KB, 8 views)
Reply With Quote
  #2  
Old 08-27-2014, 09:20 AM
gebobs gebobs is offline Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Windows 7 64bit Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Filter by Owner/Position, copy, paste values.
Reply With Quote
  #3  
Old 08-27-2014, 09:34 AM
rogcar75 rogcar75 is offline Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Windows 7 64bit Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Office 2010 32bit
Novice
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions.
 
Join Date: Aug 2014
Location: OU Country
Posts: 15
rogcar75 is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
Filter by Owner/Position, copy, paste values.

Thanks for responding gebobs.
What i am trying to do is have the rows transferred to sheet 2 if conditions are met in sheet 1

I have come up with a formula just recently i think that should work, but it isn't, maybe you could enlighten me on this formula.
I am new to this type action, so bare with me if you would.

Heres the formula i have put in sheet 2 A4
=IFERROR(INDEX(First,SMALL(IF((Owner="rog")*(Roste r="MLB")*(RIGHT(Pos,1)<>"P"),ROW(First)-MIN(ROW(First))+1),ROW(1:1))),"")

EDIT: By the way i forgot to mention when this sheet is all done their will be 14 team pages to copy and paste the rows to, i am just trying to get the formula correct before i start adding the 14 extra sheets, with about 100 rows to each sheet, so maybe you can see why i would rather use a formula to do this instead of the copy and paste action.

Thanks for your time.
Rog
Attached Files
File Type: xlsm Testformulaforsheet2pitcherposition2.xlsm (324.0 KB, 13 views)
Reply With Quote
  #4  
Old 08-28-2014, 05:21 PM
rogcar75 rogcar75 is offline Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Windows 7 64bit Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Office 2010 32bit
Novice
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions.
 
Join Date: Aug 2014
Location: OU Country
Posts: 15
rogcar75 is on a distinguished road
Default

Just a question for someone?
Would this action be better done with a formula or be done with a VBA script to handle this situation?
the top post is what i am talking about.
If so can it be done with a script and stay true to itself for the entirety, because i have a real problem getting a formula for this action, maybe I need to go back for some lessons, IDK.
Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet. rogcar75 Excel 0 08-12-2014 07:21 AM
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. From an XL sheet ,how to keep the group of columns which match with other XL sheet Zubairkhan Excel 2 03-04-2014 10:57 PM
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Find Results in excel copy the rows to another sheet khalidfazeli Excel 2 02-06-2013 09:38 AM
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions. Construct a summary sheet by summing up from one or more than one sheet. PRADEEPB270 Excel 1 11-04-2011 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft