I have NFL grid schedule I need help to replace abbreviation from Transpose worksheet sample give one team sf to 49ERS also with @49ERS.
I also need create team worksheet than put schedule
I have NFL grid schedule I need help to replace abbreviation from Transpose worksheet sample give one team sf to 49ERS also with @49ERS.
I also need create team worksheet than put schedule
Last edited by VOYAGER22; 04-01-2023 at 04:06 AM.
I have added a Template Sheet...
And...if I understand your requirement...
If not, i suggest you upload a sample file with expected outcome...and explain process...Please Login or Register to view this content.
Last edited by sintek; 03-25-2023 at 06:52 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
It did done sf to 49ers on 49ers do not have @ with it. Have a error. How I do rest teams sameway as SF. I have list on TEAMS worksheet with abbreviation and name change to. I make backup to have you press see what wrong.
Last edited by VOYAGER22; 03-27-2023 at 03:46 AM.
Thanks You Voyager22 in advance
I have no clue what you mean with Post above...
Did you even see post 2?
I try your code to my file was get error. i why post file and image of error. I saw on your file have no schedule for all teams i want teams with and without @ symbol on all teams schedules from transpose worksheet. I put schedule in column C is from Transpose worksheet. in Column B is look like but I want @ instead of AT
Last edited by VOYAGER22; 03-27-2023 at 04:00 AM.
I am guessing your file is not same as sample file I uploaded...I try your code to my file was get error.
Like I said in Post 2
If not, i suggest you upload a sample file with expected outcome...and explain process...
Last edited by sintek; 03-26-2023 at 12:14 PM.
Here is another option for you. I renamed the "49ERS" sheet to "Temp" to prevent a failure with the code.
Please Login or Register to view this content.
Last edited by maniacb; 03-28-2023 at 10:39 PM. Reason: Added xlwhole parameter to replace line to prevent combination of strings. Also corrected code in attached file
Something tells me this file of your has become corrupt...
If it is as maniacb understands then...
Please Login or Register to view this content.
Last edited by sintek; 03-28-2023 at 03:20 AM.
I saw some teams are combine & did wrong column. I want for example all with sf change 49ERS and @sf change to @49ERS for all other teams schedule
Thanks You
Post 8 works as per your requirement...
You are making it almost impossible to help...Keep on saying it doesn't work, but add no explanation or expected result...
I suggest you upload a sample file showing your expected output...
As far as I can see all the abbreviations have been replaced...and no combinations
Untitled.png
Last edited by sintek; 03-28-2023 at 07:59 AM.
Here is the correction to post #7. Sintek's solution is more efficient and achieves the same result.
Please Login or Register to view this content.
49ERS
@BEARS
SEAHAWKS
@BRONCOS
RAMS
@PANTHERS
@FALCONS
CHIEFS
@RAMS
BYE
CHARGERS
@CARDINALS
SAINTS
DOLPHINS
BUCCANEERS
@SEAHAWKS
COMMANDERS
@RAIDERS
CARDINALS
Do rest on Transpose & Teams worksheet. I show 49ers selection on Transpose & 49ers worksheets.
Last edited by VOYAGER22; 03-28-2023 at 02:59 PM.
So you are wanting the @ on The different team tabs to be replaced by AT
Like this below...
Untitled.png
Last edited by sintek; 03-28-2023 at 03:22 PM.
It's not clear what you wan to achieve. Your spreadsheet instructions say:
OPPONENTS WITH & WITHOUT @ WHEN SEE AT PUT @ INSTEAD
But the TRANSPOSE page only has "@", nothing with "AT "
When you see word AT replace it with @ instead. all teams worksheet look up from Transpose put opponents they play name of teams.
Last edited by VOYAGER22; 03-28-2023 at 06:21 PM.
[QUOTE=maniacb;5808406]It's not clear what you wan to achieve. Your spreadsheet instructions say:
OPPONENTS WITH & WITHOUT @ WHEN SEE AT PUT @ INSTEAD
But the TRANSPOSE page only has "@", nothing with "AT "[/QUOTE
Lookup from transpose worksheet all teams
Try downloading the files from post #7 and #8 and select the command button. They both do what I understand you want. If they don't, show us what is wrong.
@ maniacb...
Something tells me OP does not truly know what he wants...
The provided code does what is required...He's initial requirement...No mention of the word AT
He's sample file showing result is this...LHS for Transposes Tab & RHS for 49ERS Tab indicating that @ must be replaced with AT
Untitled.png
Now he says...
He's wasted enough of my time...I'm outta here..When you see word AT replace it with @ instead
Last edited by sintek; 03-29-2023 at 01:54 AM.
Well it is very confusing...
File in Post 8 renders the correct results...
If it does not then tell us in detail where it is incorrect...don't just say it does not work...
You can add @ as a text item in the cell by first entering an asterisk before it, like this @. That is how the code above enters that text.
Yet you still have not confirmed that all works as you wanted it..Sometime hard detail in words for me
Why is Template worksheet? If possible remove template worksheet. How did you use image for button?
Last edited by VOYAGER22; 03-30-2023 at 11:22 PM.
If possible remove template worksheet. How did you use image for button?
Here is final...No template...I made image for button
Why so concerned with image...Can be made with Excel...Insert two images and group or any other software...Photoshop, Corel Draw, Illustrator etc etc
What about the actual result that the code produces...You have still not responded to it's accuracy...
Last edited by sintek; 03-31-2023 at 04:05 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks