Recent content by JohnnyT

Thanks for the input, its duly noted. I have settled for the 0.00;red -0.00;; approach. This has worked out fine. Thanks for your help. Cheers JT

anka Thanks for that one. Didn't know about that. In this case there are other values that I want to show zero, but I'll certainly bear it in mind for the future. Thanks for your help JT

I've sorted this one out now. I spoke to the fella that made the invoice sheet up and he used one of excels own templates. I think there must be something in the formatting of this that's mucking it up. I've recreated the invoice in a new worksheet and its working fine now. Thanks JT

jproj, That's the one !! Worked a treat, thanks for your replies. Cheers JT

I have a cell that multiplies one cell by another and displays the total. The trouble is that if nothing is in the other cells it just displays a '0'. Is there a way of setting it to not display a '0' and just remain blank ? Thank you for your help John

I have a workbook with several sheets in it. The idea is that you fill in a project sheet and it automatically fills in the corresponding invoice sheet. The two sheets are called : Project no. and Invoice1 Invoice1 was our current invoice sheet that I copied into this workbook. I have cells in...

No worries, I'll get a copy over to you. Although I don't think it will be tomorrow because I'm out on site. I'll certainly get it over to you before w/e though and you can have a look. Cheers John (webmaster"StopSpam"@biscuitsbrown.com)

tomatge I had looked into that method of linking data to access but, as you say, its a little inflexible for my application. I'll give the VB way a go and make a macro from a button as suggested. If it all goes Pete Tong, I'll turn to using QuickBooks as mentioned earlier by cbiber. Thanks...

Craig Thanks for the help mate. I'll try that and see how it goes. Cheers JT

cbiber Thanks for the info.. I'll give it a look. Cheers JT

cbiber I haven't started populating the database as yet. Although I've done the work on the Excel sheet. Where could I get hold a copy of QuickBooks or have a look at what it can do? Is there a website ? Cheers JT

Thanks for your help Tim. Anyone else got any ideas about this ?

Thanks for the reply.. unfortunately I do need to use Excel, the reason being that the project sheet also costs the jobs done to that particular project (ie. hours spent on job at whatever rate, parts bought etc etc) I also want to expand this Excel sheet to automatically generate our invoices...

I have an Access database for customers with Customer Name, Customer Address (blah blah, all the usual fields) I also have an Excel sheet for projects which requires the inputting of the customer name and address. My question is this... Is there any way to link the Excel customer name box to...