If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Color Cells Summing
Hey Max & Bob,
i Figured it out in the end, the securoty was up too high ... derr.. Sorry to be a pain but can you guys help me with one last thing? i need to share some data from cells on this worksheet to another layed out work sheet and i dont know how. i know i am a pain eg : SIMON 0 16 ADRIAN 0 0 RAY 0 0 DANE 0 0 These numbers all have formulas which change when i add the colours. ( that's why i thought you could help as you did a fantastic job helping me there). Well, Happy New Year, i hope you don't mind helping me. Thanks Han -- Message posted via http://www.officekb.com |
#22
|
|||
|
|||
Color Cells Summing
Good to hear you resolved what was bugging you.
Suggest you put in a fresh posting for your new query -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- HANYANA via OfficeKB.com wrote: Hey Max & Bob, i Figured it out in the end, the securoty was up too high ... derr.. Sorry to be a pain but can you guys help me with one last thing? i need to share some data from cells on this worksheet to another layed out work sheet and i dont know how. i know i am a pain eg : SIMON 0 16 ADRIAN 0 0 RAY 0 0 DANE 0 0 These numbers all have formulas which change when i add the colours. ( that's why i thought you could help as you did a fantastic job helping me there). Well, Happy New Year, i hope you don't mind helping me. Thanks Han -- Message posted via http://www.officekb.com |
#23
|
|||
|
|||
Color Cells Summing
I've been using 2007 for a year or so now in various Beta TRM incarnations,
and I think I might just get USEDS to it by 2015! "Max" wrote in message ... Aha, great to have company here g Happy New Year, Gord ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Gord Dibben" gorddibbATshawDOTca wrote in message ... You and me both Maxg Happy New Year Gord |
#24
|
|||
|
|||
Color Cells Summing
Han,
I am not really getting the problem. Can you explain from the bottom? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "HANYANA via OfficeKB.com" u30570@uwe wrote in message news:6ba6c1ecf4617@uwe... Hey Max & Bob, i Figured it out in the end, the securoty was up too high ... derr.. Sorry to be a pain but can you guys help me with one last thing? i need to share some data from cells on this worksheet to another layed out work sheet and i dont know how. i know i am a pain eg : SIMON 0 16 ADRIAN 0 0 RAY 0 0 DANE 0 0 These numbers all have formulas which change when i add the colours. ( that's why i thought you could help as you did a fantastic job helping me there). Well, Happy New Year, i hope you don't mind helping me. Thanks Han -- Message posted via http://www.officekb.com |
#25
|
|||
|
|||
Color Cells Summing
Bob,
Happy New Year ! Ahh, I'll just roll along and let each year take care of itself g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob Phillips" wrote in message ... I've been using 2007 for a year or so now in various Beta TRM incarnations, and I think I might just get USEDS to it by 2015! |
#26
|
|||
|
|||
Color Cells Summing
Bob,
... Here's the revised sample, re-rendered incorporating Bob's suggestions g: http://www.savefile.com/files/378485 Count n Sum Cells By FillColor_BobPhillips_ColorIndex_UDF.xls Bob: Trust the revised sample is ok with you. Let me know. In the absence of comments from you to the contrary, re the above in earlier response, I'll take it you're happy with it? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#27
|
|||
|
|||
Color Cells Summing
ok, no choice then ..
I'll take it you're fine with it, Bob g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Max" wrote in message ... Bob, ... Here's the revised sample, re-rendered incorporating Bob's suggestions g: http://www.savefile.com/files/378485 Count n Sum Cells By FillColor_BobPhillips_ColorIndex_UDF.xls Bob: Trust the revised sample is ok with you. Let me know. In the absence of comments from you to the contrary, re the above in earlier response, I'll take it you're happy with it? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#28
|
|||
|
|||
Color Cells Summing
Sorry, of course I am Max. It is your file, I just made a suggestion to make
it (hopefully) better. Bob "Max" wrote in message ... ok, no choice then .. I'll take it you're fine with it, Bob g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Max" wrote in message ... Bob, ... Here's the revised sample, re-rendered incorporating Bob's suggestions g: http://www.savefile.com/files/378485 Count n Sum Cells By FillColor_BobPhillips_ColorIndex_UDF.xls Bob: Trust the revised sample is ok with you. Let me know. In the absence of comments from you to the contrary, re the above in earlier response, I'll take it you're happy with it? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#29
|
|||
|
|||
Color Cells Summing
Glad to hear that, Bob !
Cheers -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob Phillips" wrote in message ... Sorry, of course I am Max. It is your file, I just made a suggestion to make it (hopefully) better. Bob |
#30
|
|||
|
|||
Color Cells Summing
Glad to hear that, Bob !
Cheers -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- Bob Phillips wrote: Sorry, of course I am Max. It is your file, I just made a suggestion to make it (hopefully) better. Bob |
Thread Tools | |
Display Modes | |
|
|