Hello,
I am newly registered but not new to search in this forum for new approaches of better structuring my vba code. Still, now I am facing a wall with which I think the solution would be a nested loop (but I might be mistaken:confused:).
Document: 1 workbook, 13 sheets (the first is called...
Hello Excel Experts,
I found some great sets of macro that allows below actions:-
1. From ThisWorkbook, open another workbook containing data
2. In ActiveWorkbook, filter some rows of data based on criteria
3. When filtered results exist, delete those unmatched then copy the matched ones...
Hi,
I'm filtering a worksheet with 3 columns using:ActiveSheet.Range("$A3:$C10000").AutoFilter Field:=1, Criteria1:=rs("ID")
The top two rows are headings.
The third column has a UserName. When try to get the value of the UserName I use:
ThisWorkbook.Sheets("Users").Cells(3, 3).Value
I get...
This is my first spread sheet trying to use macros andvba. I am trying to sort laborers based off least amount of hours worked(column X) and also their clock number (column C). So if two laborers have thesame amount of hours the vba will then sort based on the laborer with the lowerclock number...
Hi, I was wondering whether you can help me solving a complex Excel Problem (I have XL2003). That is, I want to extract data from a table in a sheet via cell formula and display it in a new sheet. My problem is that I have dynamic criteria. That is, I am looking for a formula (no VBA) that will...
Hello,
This is my first time posting, so forgive me if I am not doing this correctly.
I have been trying to figure out how to use autofilter in vba to filter if column A has a certain value OR if column B has a certain value.
for example.
Column A Column B
<TABLE style="WIDTH...
I have not used arrays yet in VBA. However, I think using an array will be fast then the loop I am using now to determine the row number of the next visible row of autofiltered data.
For example: I filter a set of data on specified fields and the results show the following rows as visible:
2...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.