Hi Brother, need ur help to get code for. Instead of selecting region one by one . can i give in range of cells with region i required. Need the each region in seperate sheet
I have used the information but I keep getting an error on line count_row = WorksheetFunction.CountA(Range("A1", Range("A3").End(xlDown))) could you please help me with this issue.
Best of the best channel, Question, when I run it stop at this line of code "ActiveSheet.Range("A4").AutoFilter Field:=2, Criterial:=reg" error is, Application-define or Object define error. How to fix it. Thanks
For example you already have 5 sheets ready such as Asia, Eastern Europe, Northern Africa, Oceana and Western Europe arranged randomly. Then the goal is to filter Northern Africa data, copy the filtered data and paste it to Northern Africa sheet. How would you code it?
@@greggowaffles Hi I am getting the error at this statement Sheet1.Range(Cells(4, 1), Cells(Count_row, count_col))). _ SpecialCells(xlCellTypeVisible).Copy , can you please help with this or else please share the excel file so that I will update with my data, please
Help // :v i want to create a search vba Kinda like you click on it, it activate to the sheet_name = you ✅ on ( a specific cell) . Then if the sheet hasn't exist. Create a new sheet.name= what you ✅
Sir i have a problem there’s no data that have been filtered and copied. When I tried to debug, the error was in this particular code “ActiveSheet.Range(“A4”).AutoFilter Field:=1, Criteria:=owner
Sir i have required your help for Loop Criteria1 from sheet Name ecode Master data have sheet name pending Dim ecode As Worksheet Dim X As Long X = Sheets("Ecode").Range("a1:a85") Do While Sheets("Ecode").Range("a1:a85") "" ActiveSheet.Range("$A$6:$R$461").AutoFilter Field:=14, Criteria1:="=S08435" _ , Operator:=xlAnd Range("A5:M462").Select Application.Run "'Pending issuance2nd Oct.xlsm'!Mail_Selection_Outlook_Body"
This is great ! How would I adjust this to filter multiple sheets that need to be copied ? I am trying to save time in work to get off early and know there is a better way to filter sheets on a set range and remove blanks then copy the sheet into a master - each sheet has a date for a name ( dd.mm.yy) so as of typing this 20.04.22 (based in the UK) with additional text being “Do Not Use” after the date has past and each week am having to copy past weeks sheets for boss and it’s time consuming but know it’s able to be done but can’t figure the code out to do it am alright at macros but this is past my ability and struggling to finish on time every Monday as have multiple workbooks to go through and compile into a report. Would really appreciate any help on this as it’s getting more and more out of hand as it appears there is “another” book needing to be filtered out each week and know it’s able to be done quicker
🎉🎉you’re my hero 🎉🎉🎉🎉
Is it possible to run a program that will automatically create new sheet each for all available regions? that is without filtering one by one?
great video, how do you create a new sheet for each country w/o having to manually filter each time ? thanks.
Hi Brother, need ur help to get code for. Instead of selecting region one by one . can i give in range of cells with region i required. Need the each region in seperate sheet
I have used the information but I keep getting an error on line count_row = WorksheetFunction.CountA(Range("A1", Range("A3").End(xlDown))) could you please help me with this issue.
I have different headings .....copy from master file to single sheet with sheet name
Best of the best channel, Question, when I run it stop at this line of code "ActiveSheet.Range("A4").AutoFilter Field:=2, Criterial:=reg"
error is, Application-define or Object define error.
How to fix it. Thanks
Thanks! Should be "Criteria1" instead of "CriteriaI"
@@greggowaffles Thank you so much sir😊👍
No prob!
can you give tutorial on autofilter that is based on dates?
Yeah, sure! Do you have a specific example you want me to cover?
For example you already have 5 sheets ready such as Asia, Eastern Europe, Northern Africa, Oceana and Western Europe arranged randomly. Then the goal is to filter Northern Africa data, copy the filtered data and paste it to Northern Africa sheet. How would you code it?
you can use this video and change "Sheet2" to "Northern Africa": ruclips.net/video/dEAozqfZFHE/видео.html apologies for the late reply
@@greggowaffles Hi I am getting the error at this statement Sheet1.Range(Cells(4, 1), Cells(Count_row, count_col))). _
SpecialCells(xlCellTypeVisible).Copy , can you please help with this or else please share the excel file so that I will update with my data, please
Help //
:v i want to create a search vba
Kinda like you click on it, it activate to the sheet_name = you ✅ on ( a specific cell) .
Then if the sheet hasn't exist. Create a new sheet.name= what you ✅
Sir i have a problem there’s no data that have been filtered and copied. When I tried to debug, the error was in this particular code “ActiveSheet.Range(“A4”).AutoFilter Field:=1, Criteria:=owner
Which row does your data start on? Row 1, 2, 3, 4, etc.
@@greggowaffles row 4
Should be "Criteria1" instead of "Criteria"
@@greggowaffles Thank you sir.
You're Welcome!
👍👍👍👍👍
😎
Ap kya type kar rahe hai kuch samjh nhi raha jara size badhye
Sir i have required your help for Loop Criteria1 from sheet Name ecode
Master data have sheet name pending
Dim ecode As Worksheet
Dim X As Long
X = Sheets("Ecode").Range("a1:a85")
Do While Sheets("Ecode").Range("a1:a85") ""
ActiveSheet.Range("$A$6:$R$461").AutoFilter Field:=14, Criteria1:="=S08435" _
, Operator:=xlAnd
Range("A5:M462").Select
Application.Run "'Pending issuance2nd Oct.xlsm'!Mail_Selection_Outlook_Body"
hi. you can use this video: ruclips.net/video/L9BhK6Dejx4/видео.html
@@greggowaffles Thank you for your reply, I have done my work. I will watch all your videos.
Thank you for the support!!
This is great ! How would I adjust this to filter multiple sheets that need to be copied ? I am trying to save time in work to get off early and know there is a better way to filter sheets on a set range and remove blanks then copy the sheet into a master - each sheet has a date for a name ( dd.mm.yy) so as of typing this 20.04.22 (based in the UK) with additional text being “Do Not Use” after the date has past and each week am having to copy past weeks sheets for boss and it’s time consuming but know it’s able to be done but can’t figure the code out to do it am alright at macros but this is past my ability and struggling to finish on time every Monday as have multiple workbooks to go through and compile into a report. Would really appreciate any help on this as it’s getting more and more out of hand as it appears there is “another” book needing to be filtered out each week and know it’s able to be done quicker
can you give tutorial on autofilter that is based on dates?