LinkBack URL
About LinkBacks
Tried copying examples, but must be missing something.
Sheet1 - position, player, team (enter player name and the position and team should populate from sheet2)
Sheet2 - table sorted by position, player, team
Attached sample.
Tried copying examples, but must be missing something.
Sheet1 - position, player, team (enter player name and the position and team should populate from sheet2)
Sheet2 - table sorted by position, player, team
Attached sample.
Last edited by x65140; 12-10-2013 at 09:44 AM. Reason: Solved
Put this to the E2 cell and fill down...
Please Login or Register to view this content.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Tried adding the code, but didn't work. Gave me invalid formula error.
Double checked and typed it exactly as you had.
Plus, don't understand why you left off column 'A' on sheet 2, I need the position to populate on sheet 1 as well as the team
Try this one...
Please Login or Register to view this content.
Nope. Shows Manning, Peyton in CLE instead of DEN
In A2 and copied down.
Formula:
Please Login or Register to view this content.
In E2 and copied down.
Formula:Please Login or Register to view this content.
If posting code please use code tags, see here.
That worked Norie - THANKS!
Quick addition....before the name is typed in, the A & E cells have a #N/A (because the formula is in there)
How do I get that not to show.
Once the name it typed in, it populates correctly, but I don't want to see the #N/A before that
You can add IFERROR.
Formula:Please Login or Register to view this content.
AWESOME! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks