Invoice

[tofimoon4]

Dear sir,with my regards, i have sent this message to another forum but ( no reply ) asking you kindly to help me , please. Dear sir, with best regards,asking you kindly to take a look for the attached file which contains :
1- Main sheet including an invoice form 2- Agents sheet including all details that we have registerd in the invoice 3- Materials sheet including details from main sheet .
My requests are ( with hope they are simple for you ) :
1- Codes to transfer some details from ( invoice) to ( agents , materials) sheets .
2- The details i need to transfer are( coloured by orange) in ( agents , materials) sheets .
3- The invoice details should be clean after transferring data to accept another ones .
4- In the end of invoice i need a code for ( total amount ) in words .
Hopping i shall win your help .
Thanks in advance.

[mdmackillop]

Please post a link in both sites.

[tofimoon4]

Dear sir,with my appreciation , can i have more clearness about above order , please.

[mdmackillop]

Can you post a link to the other site so I determine if anyone posts before I look at this. As a courtesy, you should do the same at the other site.
Have a look at this post

[tofimoon4]

Dear sir, i have sent this order to (http://www.thecodecage.com/forumz/ex...9-invoice.html on 29/5/2009 and you can see it staying with no reply till now.
Hopping you shall help after this clarification, please.

[mdmackillop]

As a courtesy, you should do the same at the other site

[tofimoon4]

Dear sir, am i right when explaining these orders that ( there is no reply ).
Thank you for giving me some time.

[MaximS]

try that, see attachments for details:

[tofimoon4]

Dear sir,with my thanks for your interest and solution , like to inform your goodself that:
1- No data transferred from main sheet to anothers by ( update) button.
2- I have recieved this message after ( updating) : ( compile error:variable not defined) .
Hopping you shall study these matters cure.
Thanking you.

[MaximS]

change misstyped ING to INV.

it won't do anything if invoice form is empty (range c18:g39).

[tofimoon4]

Dear sir,you are wonderful,you are genius,it works very very nice,thank you very much for help.

[mdmackillop]

[VBA]Dim INV, AGN, MAT As Worksheet
Dim dDate As Date
Dim tInv As String
Dim LRow, LRw, i As Long[/VBA]
Hi Maxim,
FYI, only MAT is dimmed as worksheet and only i is dimmed as long, The other items on the row become variants. You should Dim each item separately. Lists don't follow English usage!
Regards
MD

[mdmackillop]

Hi Tofimoon,
You should now see that Patrick Molloy has wasted his time at The Codecage because you did not publish a link there as requested. ( I have now done so)

With regard to your question here, why do you provide a sample with no data. Do you consider your tiime more valuable than ours?

Repetition of inconsiderate postings will incur suspension from this site.
Regards
MD

[tofimoon4]

Dear sir,i ask you kindly to accept my apology for this an intended mistake.
Hopping it wont repeat again.

[MaximS]

mdmackillop I didn,t know that, but thanks for advice.

Can you tell me then if below is correct?

[VBA]Dim x As Long, y As Long, z As Long, i As Long, j As Long[/VBA]

[mdmackillop]

Hi Maxim

That is OK

[tofimoon4]

Dear Mr.MaximS,with my appreciation,1- is there any modification of the code will help the program more 2-is it possible to modify the code by adding column (U) in (materials) sheet which shall contains (agent)name .
Thanks in advance.

[MaximS]

hi,

1 - tell me what you want to improve and we will think about it
2 - done

see attachment for details.

[tofimoon4]

Dear sir,many thanks for help,you are excellent realy.

[hardlife]

http://www.vbaexpress.com/kb/getarticle.php?kb_id=735

Submitted by: alimcpill

Approved by: mdmackillop