Search results

Hi SirJB7, a) indeed they are both the same file, one in google docs and one in MS Excel b)the macro "NieuweFactuurStarten" is associated with the button nieuwe, but if you click on it once the contact details go back to 0 (which is a good thing). What i am trying to alter is that if you...

hello everybody, I have a excel file that i copied from the internet, i have adapted it to my needs, but i need some help with the macro "nieuwe factuur". if i click on it twice all the data goes away, i would like that the info that is now there stays there after clicking. also in the...

SUPERB! thank you... now i've got a perfect sheet....

hi guys, thank you very much the following code works brilliant: Private Sub Worksheet_Calculate() Dim LastRow As Integer LastRow = Range("B65536").End(xlUp).Row Application.ScreenUpdating = False Application.EnableEvents = False For i = 1 To LastRow 'which column are we checking for...

i have just changed all the formulas to "" at the end, but it still won't work! but thank you for this very observant remark SirJB7!

they are in col B & D. https://docs.google.com/open?id=0BzFJe5u0_x_FV3N0dURaaTBTcUdTT244ZkV3T2pRQQ

the first formula isn't working, in my cells there are some IF functions, so sometimes there are some date in it and sometimes not. but the macro that you have send doesn't if in the formula is a funciton in it... cheers

Thank you very much Luke M, but I am wondering is it possible that it doesn't work if you have already a formula in the cell cuz on a try sheet it works great but on a page where there are formula's involved he doesn't want to work :s thanks!

hi, i am looking for a macro/formula that if the row is empty that it hides itself, but the row has to appear again if the formula that is in that row gives a result. And is it possible to have a date changed in a cell if you have changed something in the workbook. So if you don't change any...

thank you very much! this is exactly what i needed

https://docs.google.com/spreadsheet/ccc?key=0AjFJe5u0_x_FdExMeFQ2UmtLSUxMTWdpcERzSmRFSEE here is the link open to changes :)

https://docs.google.com/spreadsheet/ccc?key=0AjFJe5u0_x_FdENQOUd0Q191cklpUlA0YXN6RzZmU0E#gid=0 on the sheet fill in: there is a dropdown list of some machines, it should look there and then select which sheet it has to find the information for the proforma

superb thank you very much, but unfortunatly i can't upload a file cuz the file is a calculation sheet for my job.

I have a question: I have a dropdownlist of cars and I have a for every car a different sheet. On the sheet invoice I want that all the specs of the car appear once you have selected a car in the dropdownlist. Is this possible to do in Excel and if so could somebody tell me how.