Adding times to worksheets

Hi Thomas,

Please add your workbook here.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary, and please remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here you go

let me know need more info


Time from Yearly or 1-17 worksheets to put into
PATRIOTS FOR FRIENDS
STEELERS FOR FRIENDS
CHARGERS FOR FRIENDS
CHIEFS FOR FRIENDS
COWBOYS FOR FRIENDS
EAGLES FOR FRIENDS
49ERS FOR FRIENDS
CARDINALS FOR FRIENDS
RAMS FOR FRIENDS

TY
Thomas

Okay. First thing. You are going to have to make all the team names match from the Yearly Schedule tab to all the Friends tabs.

Now on the Patriots tab in F5 copied down

=INDEX('Yearly Schedule'!$I$2:$I$257,MATCH(A5&"|"&B5&"|"&$A$2,'Yearly Schedule'!$A$2:$A$257&"|"&'Yearly Schedule'!$D$2:$D$257&"|"&'Yearly Schedule'!$G$2:$G$257,0))

IMPORTANT

• This is an array formula
• Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
• If entered correctly, the formula will be enclosed in {brackets}
• Do not enter the {brackets} manually

Thanks you that formula. In that formula create when Teams for friend When say BYE should leave Time column empty

Does this work for you?

Hi Thomas,

I'm sorry but I don't understand what this means. Can you please update your request so it's a little clearer and also post your worksheet to the forum versus a hosting site?

3 sheets for friends sheets have #NA where time should be. look on the file please Thanks You

3 sheets for friends sheets have #NA where time should be. look on the file please Thanks You

I don't see that problem with what I posted in post #12. If you post your sheet to this forum I can take a look, but I suspect the below.

Okay. First thing. You are going to have to make all the team names match from the Yearly Schedule tab to all the Friends tabs.

I fix AFC teams problem

NFC Teams the formula is in the pictures some not woking say #NA. I make sure teams is same in Yearly Schedule and Teams for friends worksheet

https://1drv.ms/x/s!AnJwxxiz0Ezpg8FV...qwbrQ?e=CcqwiJ

Please Login or Register  to view this content.

Thanks You

Thomas

Hi Thomas,

I'm glad you fixed the AFC, but pictures do me no good and you did not post the attachment on this forum.

I zip it up it to large attached byself

The 2019 NFL schedule has the Cowboys playing the Giants in week 1. On your sheet Eagles for Friends, you have week1, Cowboys vs. Eagles. Not a match.

Bottom-line: Nothing wrong with the formula