Search results for query: *

ok, just have to value range it if i need to forward it. thank you

hi skip, here's the formula =SUM(OFFSET('[Global Qr View 2003 actuals.xls]260000 North America'!$D54,0,1,1,Info!$E$27)) thanks for looking into it. peter

thanks for the joke, need a laugh here.... well, i kinda like to send the spreadsheet to someone else without sending the supporting spreadsheets.... is this a problem with offset only since a simple link doesn't have the same problem. thank you peter

hi all, need your help here... i have an offset function with reference to an unopened spreadsheet. It comes back with #value! msg. If the spreadsheet is open, then the formula works. both spreadsheet are on the same directory. I am running excel 2000 sp3. APPRECIATE ANY HELP YOU CAN...

offset problems.... I have a offset formula which references another spreadsheet which works fine when the referenced spreadsheet is open but gives a value# message when it is not????? Please help... thank you. running excel 2000 regards

Hi foolio12/franksirvent, I need to use this too to remove the carriage return from the table itself. how do I do it? (access 97/2000) don't seem to be able to use the replace function in a report or query???? any help will be much appreciated. thank you pk

hallelujah!!Amen!! thank you so much, storm75m !!!! wouldn't have figured that out in a million years peter

Shadylane, in additions to vic's comment, you may want to surrond your fields with [] to make sure that access understand that they are fields. peter

help!!! The line below "error here" is using the openrecordset method to return a record set. However, it merely returns a "type mismatch" error instead. Any suggestions would be helpful. I had looked at the references and found the following: Visual Basic for...

For example, region Cust id Product A 21 a1 A 21 b2 B 21 a1 B 21 b2 I would like to see region count of cust A 1 B 1 thank you in advance

thank you! i got it to work! amazing peter

Hi i am new to Excel VBA but have some experience in Access. I have a macro that will update the dependent pivot tables base on the first one using the worksheet_change trigger. However, when the pivot page dropdown was change, it didn't work - only if other cells was changed. If I use the...

udai, link does work - am using ie 5.5 p

i am trying to link two pivot tables together so that when the page field of the first changes it will change it for the second. any ideas? not familiar with VBA but will try anything.

webrookie, if you change the sort to manual, the order of the rows will not change during change of the page thingy. regards pkhoo