And what if the sheet has filled with only one row? Ur code will select all the rows in excel and the next file will never gets consolidated please correct the code
Yes, all should be the same or you need to modify the code according to your file. You can send me an email with detailed information. Krishsexcelanywhere2020@gmail.com
First copy the range: example the below method will remove the formula Activesheet.range("A1:B10").Value = Activesheet.range("A1:B10").Value 2. Example Range("A1:B10").PasteSpecial
Enable editing file epadi Macro la eduthutu varathu and unga video la data thaan elam file kum iruku but yanaku received aagura file la elam current date la varum. Oru 20 to 30 file. Athalam epadi ithula pannurathu
@@SanthuAnalytics9510 yeah bro that i changed already.. i have prepared three files... with my own pc.. Bur aftet i applied to the office working file nothing is working
Hi, I am not sure which drive you're referring to. If you're using a local desktop then you could find it in the recycle pin. Else you have to check with your the IT team
Hi Anna, it's really help full vba macro code
Thank you 😊
Ur videos are really helpful and keep doing.
Thanks a lot for your support 👍
Hi sir
Can we use this script and modify and use to combine multiple worksheets present in one excel file
Hi Sir, thanks for your amazing session , just i have a query any one workbook is Blank then it shows the Bug in code, could u help this one
Hi, I hope this video will help you to solve this problem
ruclips.net/video/kQ-ZMPVAPf8/видео.html
Hello anna.. this is really helpful.. could you pls tell me how to use the file path to select files instead of selecting manually from the folder
Thank you for your support and feedback. It's simple you can use this code example - Workbooks.Open "C:\Users\Desktop\myFile.xlsx"
@@SanthuAnalytics9510 thanks anna
Thanks sir... It's very much useful.
Thank you 😊
Bro is it possible to get data into one sheet from different more than 500 workbooks. Which as you used above same program? Pls confirm
Bro how to bypass the excel file if i don’t have the sheet name called “data”. The loop should not be affected.
Hello, yes you can remove the sheet name and make it "Activesheet". That will work based on your requirements
Hi ji this video helps me very well but the thing is only one file copy paste 3time out of 5 file so pls help me on this
Hi, thank you for your feedback. Could you please send me your file and code to Krishsexcelanywhere2020@gmail.com. I will check and confirm
Hi thanks
Ippo oru excel book la mattum multiple sheets irunthalum eppadi code pantradhthunnu sollunga
Hi, we have to create the vBA code accordingly. I will try to upload video for the same
Superb sir
Thank you 👍
Instead of row if I need to copy paste next available cols, how to code?
Hi Bro if all excels contains two tabs with same name in all excels.how to combine tabs accordingly
We need to use code to read for each sheet. I can help you please connect me here - krishsexcelanywhere2020@gmail.com
Send me your sample of files with dummy data
Anna ithula multiple files select panromla adhu maathri folder epdi select panrathu (antha folder kulla multiple files irukura maathri).antha folder select pannuna files select aaganum.adhu epdi?
Hello, Adhuponra video innum podavillai. Neram kidaikkum poludhu try pannara. Thank you 😊
Hi Bro useful information.
I am getting error in Active sheet.Range.
Can you please help
Hello, it should be Activesheet.Range(). Sure I can help you please text here - 9481829511
Hi am getting error in activesheet range
Hi bro can you able to use chrome by Excel marco
Hi Ram, you can open a browser but there's no way to take action in chrome by using Macro
Hi bro if the workbooks is password protected with same password how to add the module for that please reply
Hi bro, I am not able to understand your question - do you want to add a password to the model?
Hi bro got the solution and now i have one more query if we want the particular date alone from all the files what code need to apply into this
And what if the sheet has filled with only one row? Ur code will select all the rows in excel and the next file will never gets consolidated please correct the code
Good question. You can add if condition. I created the macro based on the requirements but you can change the code while you're creating 👍
@@SanthuAnalytics9510 can you plz add the conditions here
this line i get error
Sheets("Data").Select
i have different sheet name in workbook what i do
Hi, please add the sheet name that you have instead of "Data"
@@SanthuAnalytics9510 thanks for your reply, i have different sheet name
ex: book1-sheet1
book2-sheet2
Yes, all should be the same or you need to modify the code according to your file. You can send me an email with detailed information. Krishsexcelanywhere2020@gmail.com
if any possible to paste in different separate excel?
This video will help you.... Covered most of the scenarios 👍👍
ruclips.net/video/AHjIy8maU1Y/видео.html
Yes, Sir thank you so much
You're welcome
Sir enaku oru doubt sir vba la yepadi pastspecial Value + add
First copy the range: example the below method will remove the formula
Activesheet.range("A1:B10").Value = Activesheet.range("A1:B10").Value
2. Example
Range("A1:B10").PasteSpecial
ActiveSheet.Range("A1:" & vcol & vrw).Copy Error coming sir
Hello, see if you have created variables....
Is it possible for me to have this code? many thanks 🙏
Hi, please send me your email id to Krishsexcelanywhere2020@gmail.com
Sir ippo income and expense le category wise consolidate pandradu eppdi sir
Hi Sir, I can help you if you provide me more details via email.
Hi Anna enaku multiple CSV file multiple sheet open ena code use pananum
Enable editing file epadi Macro la eduthutu varathu and unga video la data thaan elam file kum iruku but yanaku received aagura file la elam current date la varum. Oru 20 to 30 file. Athalam epadi ithula pannurathu
Hi Arvind, I am happy to assist you on this during weekends. Will help to current date and data. Can we connect on Saturday? WhatsApp - 9481829511
@@SanthuAnalytics9510 is there any charges???
😊 It should be free. In case if it takes more than a day then we should discuss
Anna how to merge multiple txt file into excel sheet
Hello, text file in excel? If yes, there is one more video I have posted for the same
Very helpful
Thanks 👍
If I want to add CSV files what is the code to write
Hi, please try "*.CSV" in place of xlsx format
I want to copy both xlsx and CSV format file, in CSV files sheet name differs in each file then what will be code?
Thank you Anna....
Thank you for your feedback 👍
getting error bro "fileopen = application.GetOpenFilename(filefilter:="microsoft excel file(*.xlsx"), *xlsx", Multiselect:=True, Title:=file merge")
You should not add double quotation inside the bracket. wrong (*.xlsx") correct (*.xlsx)
@@SanthuAnalytics9510 ok bro.. will check and let you know thanku
bro excel 365 la endha codes um work aaga matikidhu but 2007 la work aaguthu
Yeah, if you older version then you should use xls instead of xlsx
@@SanthuAnalytics9510 yeah bro that i changed already.. i have prepared three files... with my own pc.. Bur aftet i applied to the office working file nothing is working
Hi
Please tell me how to download delete file from drive
Hi, I am not sure which drive you're referring to. If you're using a local desktop then you could find it in the recycle pin. Else you have to check with your the IT team
No. I'm asking for download multiple file from drive using VBA code
Bro intha video marupadiyum innum clear aa explain panni poduringala
File location enaga bro intha code la kudukkurom
@@Naveen0497 I haven't define any folder location since I added "Getopenfilename" which will open the window you have to navigate to the folder
Sure, I will try best
@@vipkatrathaikarpipom-7033 TQ brooo...
Already replied thank you
Hi bro i am getting run time error 9
After sheets("Time").select
Code
I figured it out bro. Thanks for teaching
Facing paste special xlpaste all error ( clipboard fully and excel error popup showing)
Bro!?
Send me your error message to this email id - Krishsexcelanywhere2020@gmail.com
Please give that code easy to paste my Desktop
🙄🙄🙄🙄🙄
Hi bro -
x = 1
i = 0 ----> Getting error as variable not defined
Pls assist
Hi, can you share your code with me - 9481829511, I can have a look
Run time error 13 show aguthu bro excel file yethume show agala
Hi, we have to connect and check on it
Same I can run multiple sheet.
Yes 👍
while doing large data on excel error occuring
I like to learn vba couse sir !?
waiting for reply
I thought I had already replied to your message. Sure, I can help you. Please WhatsApp me your details to 9481829511
👌👌👌👌👌👌
Thank you
Run time error 9 shown me sir
Hi, we need to review the code that you have written
Shall I share ur mail id?
HOW TO CONSOLIDATE ABOVE 5 LACS RECORDS
Hello, the file will accept up to 10L but it will take time since the file size is getting increased
Run time error 1004 varuthu sir
Sir, we need to review the file and code
Send me an email to Krishsexcelanywhere2020@gmail.com
Error varuthu bro enakku
Hi bro, please send me an email Krishsexcelanywhere2020@gmail.com
Code please
Sure, please send me your email id - krishsexcelanywhere2020@gmail.com
Please provide code
Hello, please provide your email id to Krishsexcelanywhere2020@gmail.com
Bro please reply for my msg
Where? May I know your question?