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

Thank you for this tutorial, it was very helpful. If I wanted to save a PDF to a specific folder of my choosing, do I just remove the file path?

Thank you

No voice ? C'mon.....poor approach.

already you have written all formulas so its difficult to understand

Mine has error of type mismatch. I followed everything in the video. This error is for the new invoice. My Invoice number did not change but it clear all the contents that I have listed in the range. How to fix?

How to save entire workbook.?

How do you filter the number column

It is really helpful. With explanation will be powerful. Thank you for sharing ❤

Howdy. I have a problem and I don't know what to do. Now tables with headers appear automatically when I click on tables and ok, although I don't want them to appear with headers. What can I do? do you think you can help me? Thank you

bro you are a legend. highly appreciate your efforts

Is there any way I can set the path to onedrive path that starts with https?