I need to make Purchase register for this I need to copy the data from different cells and paste in this register, for this it will take long time. For this I am going to prepare Macro recording. But what happened,here if I record 10line's suppose it will record 10lines every time. But as per my purchase order of suppose I entered only 3lines instead of 10line's it will take only 3lines, and next time if I entered 5lines it will take only 5line's for that register. Then only it's possible to make Purchase register. And kindly note sir some cells having formulas also.So kindly do this kind of very useful video with macros recording option button. God bless you sir thank you
मैक्रो रिकॉर्ड करने के बाद किसी दूसरी शीट पर रन करने के लिए उसका नाम भी same रखना पड़ता है।क्या ऐसा हो सकता है की शीट नेम से कोई फर्क न पड़े और मैक्रो हरेक शीट पर रन हो जाए।
भाई में जो ढूंढ रहा हू वो ऐसा है कि एक शीट में save button बना कर जब दूसरी शीट में डेटा ट्रांसफ़र कर्ता हू by macro बटन.. तब दूसरी शीट protection के कारण error मारती है. उसका solution चाइये
Great ..Sir in my work every day same sheet down load this download sheet pull data my master sheet but this process macro not work..sir download sheet name same but not work..
Great video....Sir , if possible please add a facility on ur channel "Assignment Facility" viz. Sharing the Excel file in description for practice as an Assignment....It will really relate ourselves to ur videos....!!
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
Fantastic video sir, so helpful for me.👍
Thanks - Nice explain ☺️☺️
For loop se cansolate bataye pls 💐💐
Excellent dada
Thanks Mr. Amit Jain
Amazing sir
Cool
jabardast
Mast yaar
Nice tutorial, keep it up...
Bhai ji thora data zoom karke sikhaiye
the first example was awesome. i will use it to automate my reports
if i want total sum of "actual revenue" in different region ????
how i record macro for it
Subscibed
I need to make Purchase register for this I need to copy the data from different cells and paste in this register, for this it will take long time. For this I am going to prepare Macro recording. But what happened,here if I record 10line's suppose it will record 10lines every time. But as per my purchase order of suppose I entered only 3lines instead of 10line's it will take only 3lines, and next time if I entered 5lines it will take only 5line's for that register. Then only it's possible to make Purchase register. And kindly note sir some cells having formulas also.So kindly do this kind of very useful video with macros recording option button.
God bless you sir thank you
Can you please share your issue in excel with example so that I can address it correctly.
मैक्रो रिकॉर्ड करने के बाद किसी दूसरी शीट पर रन करने के लिए उसका नाम भी same रखना पड़ता है।क्या ऐसा हो सकता है की शीट नेम से कोई फर्क न पड़े और मैक्रो हरेक शीट पर रन हो जाए।
Tnx sir ye shikane ke liye.
Abb aap Excel to tally me data trf kana ka shikhado bohat logo ki help ho jayy gi
rally useful for professional bas aapko thoda presentation ko thoda aur better karna hai
भाई में जो ढूंढ रहा हू वो ऐसा है कि एक शीट में save button बना कर जब दूसरी शीट में डेटा ट्रांसफ़र कर्ता हू by macro बटन.. तब दूसरी शीट protection के कारण error मारती है. उसका solution चाइये
You need to you unprotect that sheet using that macro and then protect after data transfer.
@@fintaxprime लेकिन बार बार ये काम नहीं करना.. स्मार्ट काम चाइये.. और एडिट, व्यू और अपडेट button by मैक्रो भी ढूंढ रहा हू
@@pankajknowledgeworld You don’t need to do this again and again. You need to unprotect and protect within your original macro.
कोई वीडियो मिल सकती है क्या
Excellent sirji
Thanks sir
Sir, i want to paste formula of B2 in whole Column B Dynamically, in Macro. Is it possible
Hi sir good morning
Good morning.
U r excellent sir
Great ..Sir in my work every day same sheet down load this download sheet pull data my master sheet but this process macro not work..sir download sheet name same but not work..
I'm waiting for your reply
Just replied.
Sir agar daily new workbook se data copy krna ho to kya karey
Run time error 9 aa rha hai
Please help
thanks for sharing information. awesome video sirji.. please share the video for formula where even-though invoice no not matching we can do the reco.
Great work sir..
Respected sir,
Add-in function ka use kya hai in macro.
Kindly help us.
Thank You.
Great video....Sir , if possible please add a facility on ur channel "Assignment Facility" viz. Sharing the Excel file in description for practice as an Assignment....It will really relate ourselves to ur videos....!!
Good idea. I'll definitely do the same.
Where does u stay sir
Delhi NCR
Please prepare macros for GSTR-2 DOWNLOADED sheet from GOVERNMENT SIDE FOR ZERO AND TOTAL REMOVE
Maja aa gya