Search results for query: *

Is it possible to connect to my network from outside if the network is peer to peer through my d-link 704up router using microsoft vpn?

MisterC, I put it in the section you suggested and it did indeed copy the input over to the invoice sheet when I clicked on the Invoice sheet, however it seemed to go into an endless loop back and forth from sheet1(order) to sheet2(invoice). I had to end excel and restart it. Any ideas?

MisterC, Thanks for the protect/unprotect. It works fine. 1. I'm not sure where to exactly put, Private Sub Worksheet_Activate() CreateInvoice End Sub I've tried it in a few areas under and over the active events (what i think are activate events). It doesn't seem to work. Perhaps...

MisterC, Thanks for your generosity and your humour. I ajusted point #2. you were right of course. It was reading the totals from the sourse sheet. No doubt you know that I am a novice at this, so saying that, 1. How do I 'call' the code from the Invoice sheet's Activate event so that it...

MisterC et al, Thank you for the code. It works beautifully. 2 questions remain. 1. Can this macro run automatically when there is input or do I have to say 'run macro' or by using the shortcut key? 2. More importantly, the code runs a subtotal and total calc. Is there a way to remove this...

I ask the 2nd question because it seems to work better when it's a fresh worksheet.

Thank you so much. Just a couple of questions. It's looking better. Please forgive the naive questions. 1. Where do I place the 'clear' code from above? In the same macro? 2. Can I use this macro in the 'Invoice' template or do I have to start fresh?

Maybe I didn't clear it properly 1st???

And it's listing all the rows, there is no selection of quantity >0 then input...

MisterC, I've changed the assumptions to run from 6-200 (that is on Sheet1) I hope that is correct I want it to start on row 19 on sheet2(Invoice) And I've changed the columns to F,A,D &G However on the output(invoice(sheet2)) It starts on row 6, and the colums are still B,C &D So obviously...

MisterC, Your timing is excellent!

MisterC, That's it. I think you have the answer that may resolve this issue. I would be very grateful if you would post me the code. Tks, Russell

Thanks everyone! We're almost there. Mike came the closest (I think) to what I want to acheive. The only addition I need is that if on the source sheet there is no quantity that it not be included on the invoice as an empty row. And that the next row that has a quantity on the source sheet...

Specifically, I have a few columns in one worksheet that include quantity, description, price plus some other columns. But these cells are the most important. The next worksheet is a standard invoice sheet. I would like to automate that if a quantity appears in the previous worksheet that...