Title/Award breakdown

[LeeAnne McAdam]

True, it was written as a PC-based sub-routine.

Sharon

 
I understand none of that!  LOL

[Amy McGovern]

I'll be glad to test but the attachment isn't showing up

-Amy and the schnauzers

[Shirlene Clark]

Thank you Chris Nelson and Tim Spring.....  I have advised Australian exhibitors to log onto the forum to give the spreadsheet a go and the feedback is they love it

[Carole Sparks (AUS)]

Thanks Chris for the spreadsheet that is totally awesome stuff.

[SpringCrew]

I'll be glad to test but the attachment isn't showing up

-Amy and the schnauzers

Should show up soon.  It is await approval by the moderator.

[SusanAxe]

Hi Chris and Tim,
Ive put in Hectors nadac number, no yellow box showing up, but still showing no results found.  Not sure what else I should do.  I am using a mac, is this the reason.  I have no other computer.

[Shirlene Clark]

Hi Chris and Tim,
Ive put in Hectors nadac number, no yellow box showing up, but still showing no results found.  Not sure what else I should do.  I am using a mac, is this the reason.  I have no other computer.

Susan go to reply 44 and use the MAC version of the spreadsheet

[SpringCrew]

Hi Chris and Tim,
Ive put in Hectors nadac number, no yellow box showing up, but still showing no results found.  Not sure what else I should do.  I am using a mac, is this the reason.  I have no other computer.

Try this one.

Tim

[Amy McGovern]

It still didn't work   I'll be glad to keep testing the mac version.  I've never programmed in excel or I'd help fix it (I am a programmer). 

-Amy and the schnauzers

[SpringCrew]

It still didn't work   I'll be glad to keep testing the mac version.  I've never programmed in excel or I'd help fix it (I am a programmer). 

-Amy and the schnauzers

Try the one in 52.

[Janice_Shavor]

I am now on a mac.  I could open the spreadsheet but how do you get it to interect with the points lookup?

[SpringCrew]

I am now on a mac.  I could open the spreadsheet but how do you get it to interect with the points lookup?

It should automatically prompt you for your dog's NADAC number.  If it doesn't it is because Macros are not enabled.  For the macros to work you must allow macro by Selecting Tools->Options, Click on the Security Tab (pre- office 2010, 2010 is under File, Options, Trust Center, Trust Center Settings, Marco Settings - set to disable with notification).  Click on the Macro Security button.  Set to Medium.  This will prompt you when you open a file with macro if you want to enable them.

[Janice_Shavor]

Ah!!  I am not actually using Excel.  For the limited amount of spreadsheet work I do, I tried Numbers.  I will check on the forums and see if Numbers can import macros. 
Thanks

[Amy McGovern]

Hooray it worked!  On my mac!   Thank you!

-Amy and the schnauzers

[SpringCrew]

Hooray it worked!  On my mac!   Thank you!

-Amy and the schnauzers

Glad it is working for you.  Helps when I use the right file for the starting point.