Відео

saved me a lot of stress! can't thank you enough.

THANK YOU BUT IF YOU COULD MAKE ANOTHER WITH A VOICE TAKING YOUR TIME FOR THE RECEIVER TO UNDERSTAND BETTER

Hi, Do you know if there is a way to do this using apple mail instead of outlook? Thanks

How do we contact you?

how to create table Top heading Customers

is there a way to clear content on merged cells when we are using vba for create new invoice?

Mera leye invoice bnasakte i will pay you

This is a great little piece of code. Thank you for posting. I have a follow-up question. In my spreadsheet I need to concatenate three cells to make the new sheet name. I have that part working, but it only triggers the rename when the first cell is changed and I'd like it to update when any of the three cells is changed. I've tried nesting some IF statements but haven't gotten it to work yet. Maybe a finite loop where the cell numbers change? Open to suggestions.

Please send an exel sheet or pdf shortcut key bro

Bro

hi there. i wonder if you could help me with one issue, as follows: I cannot get the PDF writer to accept my syntax when trying to add to the file path name the date of the invoice. In other words i want to add to my file name as an example the Invoice Number, plus the date,. I've tried to save the date in a variable and then replace this variable tin the file name but the PDF writer doe not like. example: Dim filePath As String filePath = "C:\Users\martin argimon\CMA\CMA Realty - Documents\Administration\ICT\Database Program\Remittances Owners\" & _ "Remittance Lease No." & leaseno & " " & Format(WS2.Range("J14"), "yyyymmdd") I would want to save the date in a variable and then call on the variable in the file path name. As you can see i have used the 'Format' range function, but when i insert my variable : 'invoicedate = Format(WS2.Range("J14"), "yyymmdd") ' Combine the file path with lease number and invoice date Dim filePath As String filePath = "C:\Users\martin argimon\CMA\CMA Realty - Documents\Administration\ICT\Database Program\Remittances Owners\" & _ "Remittance Lease No." & leaseno & " " & Format(WS2.Range("J14"), "yyyymmdd") it does not like it?? any tips perhaps ? Thanks Martin

Hi There , thx a lot for your excellent video. I have tried to add the 'date' to my invoice into the file path, but the PDF writer does not like my syntax. I will like to save the date in a variable rather than 'formatting ' it into the path.... The reason for creating a variable with the date of the invoice, is to enable me to use it in other sub-routines . is possible that you can assist with the correct coding ? I can send you my sub-routine for you to inspect?/ Thanks in advance . Regards Martin

getting problem while using 6k line entries, very slow... any twicking needed

Ms word possible?

That helped a lot. Thanks and thumbs up

Is there a way to Fill the PO with a form? Make a simple Form that auto completes the fields in the PO such as Vendor, Price, and all that

Hi there. Thanks for your video. it has helped me a lot in setting up my invoicing system. There is one Snag that i do NOT know how to handle. I wnat to add to my file name the DATE of my invoice and PDF does NOT like my code. What is the correct coding so i can include this in my file name ?> . kinldy assist. Many Thanks. Martin ( south africa)

Konjam slow a solli solli panna nalla irukkjm😊

Tell me...what is the code of ...merger cell clearcontents

Thank you. It is working.

I have Subscript out of range (Error 9) for this Set nextrec = Sheets("Summary").Range("A1048576").End(xlUp).Offset(1, 0). Please help.

Very interesting and easy to understand, looking forward to next contents.

Can you provide me

I need this file

Hi

did you create your invoice from scratch and would it work if i choose a direct invoice template from excel?

Loved your video...thanks for sharing. Is there a way to combine both search boxes as a single search ? Search will look thru Customer and Region columns as you type using VBA.

Can we filter instead of starting letter

Thanks a lot! It works wonders :)

How to export all invoices instead of clicking one by one and changing to next customer?

to much fast

It's perfect. But how to check/amend previously made invoices?

Really it's working, Thank you very much💞

spiderman coming 6.67 Hours coming but 6h how to come 67 min 60min = 1 hour. that means 7.07 correct ans

Martinez Ruth Martin Michelle Walker Susan

How to create table name ?

Thank you so much Bro💚💚💚

Brother need your helpt

how to get back to select all filter after im done using search and not click the select all in the filter??

You are doing stupid fast, no explaination, how can somebody learn, better dont do such video

Great video !! But i have similar kind of problem where im getting 2 excel files - 1 contain dashboard file with invoice no and Amount and another file contains the invoice amount breakup by resource we have to get the info from these 2 sheets and mentioned in our template sheet( invoice format sheet) and create pdf … can we create some automation for this task ? And how

I am unable to record the summary, please guide me.

V lookup

Thank you.but i want to save pdf all sheets , can you help me.

it could be a great help if it works - can you plz help: 2 problems - 1) when i moved the searchbox over the linked cell and try to type on the search box is keeps saying reference not valid even i changed the linkedcell under Properties. 2) put in the VBA code, changed table name, nothing happened (but that could be linked to problem #1?).

please reply dijiye

Bhai aapki Instagram id dijiye uspe achhe se baat ho payegi

bolo bhai

bhai please aapka koi contact no. ya koi bhi contact krne ki cheez do me apko pay krne ke liye taiyaar hoon mujhe excel me help chahiye

How can I get hold of you so you can do somework for me I can't find you on fiber