Thanks for your help Dreamboat, I had difficulty E-mailing you twice, but I donT want to bother you too much, I can get by with what you hacve shown me, I really want to make the product codes numerical so with the long weekend upon us I will have a go
best regards
jim
Hello all
Especially Dreamboat
I have a .xls file wih an invoice which accepts the product codes (from the underlying worksheet), and fills in the next line on the invioce with the whole product name, but for some reason, it now only seems to pick up the first similar product
Any help is...
Thanks for your input lads
Since my post I have found out that their is an isue with the xp system and Office 97 Professional, this is caused by a font, Microsoft had me find a file called hatten.tff, the rename it as hatten.old (press enter) restart my PC and reinstall Offfice after 2-3 trys...
All
Buying a new XP computer could be much more expensive than you might have realized, Office 97 professional is rejected with the message [ No licence on this machine ] if you have to have it to work you can upgrade to Office XP for £250 without VAT, the drawback is that this software will...
Hello excel fans
I have a problem with percentage returns in excel,
A1 = 1.28 B1 = 2.2 C1= 67%
Should return 4.70
Returning 3.70
I had a HLOOKUP table and found it didn;t work out right, the table based on a named range is the same as the above but Ihave used different cells...
Hi all
Can anyone tell me how to overcome this problem, I cant enter 1,2,3or 9,0 in word or excel, I have reinstalled Office 97, windows 98 and the sr1 and sr2 patches
Heeee l p
Jim
Hiya all
my computer is a windows 95 75 pentium. 1995 -
When I removed the RAM an error mesage came up about getting an upgrade, this is probably the bios upgrade from iCL Fujitzu ergopro x which is the PC's spec, as I am not familiar with BIOSes I left the bios and set it to reload on exit...
Dreamboat
You can have my email jim@baconaneggs.demon.co.uk
That is exactly the sort of thing but I am not familiar with the 2 page connection I need to get my head around that.
Best regards
Jim
Hey dreamboat
Your saucy.. apologies to all I have tried to get back but have had to wipe my pc and start anew .
Heres what I wanted to do
#10 numbers which are constant and ascending they could be fixed prices, and it would be easier to enter numbers 1 to 10 which represented these ten...
bkpchs237
Yes thank you very much for your time and trouble. I have had a little study and must admit i was under the impression that i could put a whole range of data say =HLOOKUP(A1:G1,RANGE,2)
And be able to copy down .. that doesn't work
=HLOOKUP(A1,RANGE,2) copied over cell to cell will...
Hello all
I need to code a VLOOKUP and have named a range.
The problem is using the wizard, that is confusing , my range has two lines the top is numbers i want to put into a range headed TOTAL at the right hand of the form.
the second line is the values they represent.
1 2 3 4 5 6 7
$2 $5...
Gord
I had this troble before , when they brought out windows 98 my 95 work would not update to 98 but 98 work would in 95 .
I got over this problem though by deleting the cog icon in my floppy which says that the actual database your running is open, if you know what I mean , the icon that is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.