Hello Gurus,
Good day!
Could you possibly help me tweak the code below? Scenario is I have to delete the data that is below 500 including blanks and zeroes in Column E. Headers is located in Row A
Sub DeleteRowIF()
Dim zlr As Long
zlr = ActiveSheet.UsedRange.rows.Count
With Range("A2:AZ"...
Howdy dear forum members,
Odd title I agree.
So I have sheet 1, sheet 2, and sheet 3.
Sheet 1 is the overall data entry dynamic table. Data is added through a User form (button "Add new entry")
Sheet 2 is where filtered data (per department transactions) is exported through a macro (see...
I am trying to pull the data from the first row (E1, F1, G1 ...) based on a certain condition. If col D - "Penetration limit" is equal or greater than the data between row E to V, i need the row name(E1, F1, G1 ...) to show up under the respective col C.
Example: in Row 4 ---- D4= 40% and N4...
Hi there,
I hope that you can help me.
I am wishing to copy and paste rows from a donor worksheet to a recipient worksheet based on one of 2 criteria being met in column H.
When the appropriate rows are copied across there are gaps in the recipient worksheet pertaining to the questions that...
I have a code built that, upon clicking a command button, displays an email to a coworker when a cell in column P is "X". When a cell in column P is updated a date stamp is automatically entered into the adjacent cell in column Q. How do I update my code so the email displays only if the...
Hello,
I want to create a X/Y scatter chart to plot projects Final Amounts Invested amounts & % and use slicers to select one or more than one location.
I have numerous locations and each location has a different number of projects to be included.
This number of projects changes each month...
Hi all,
Looking for a formula that will give me the result of the most common text within my dataset.
I currently have, for the first common text result the following formula :
{=INDEX(tblMain[Placement Provider],MODE(IF(tblMain[Reporting Fin-Year]=RIGHT(E4,5),IF(tblMain[Placement...
Hello,
Would like assistance to run a query in Access for the table below, where the ID is a text format.
Date
ID
Value
4/15/2020
ABA
2.00
4/15/2020
NHB
1.00
4/19/2020
BBB
0.222
4/20/2020
RRRf
1.55
5/1/2020
NNN
9.55
5/2/2020
JUY
2.22
5/2/2020
YYY
2.22...
Hi guys.
Is there a way to edit the below formula so that the worksheet name is referenced to a cell?? - "2020" is a cell.
=HYPERLINK("#"&ADDRESS(MATCH(A4,'2020'!A:A,0),8,1,1,"2020"),"Link")
Hi there,
I'd like help creating a macro that allows me to essentially copy and paste information from one worksheet to another based on criteria that will save a great amount of time were it done manually. In the main worksheet I have a column labelled 'Reference' and a column labelled...
Hello,
I am looking some help in getting distinct count by criteria. For example if you refer the below table I brought the distrinct count by using formala {=Sum(1/Countif(A:A,A2))} however, in additon to this need another conditional criteria. If given % different for no then it should...
On sheet one I have event dates in column C starting on row 7 and ending on row 105, event names in column D starting on row 7 and ending on row 105, and event type drop down in column F starting in row 7 and ending on row 105 with a color coded fill that changes with event type in column E...
Hi! Here's my problem. Basically, I need the data that is on the table on the left to look the one on the right.
Order IDs listed on B, the item/s ordered on C, and the status is on D. I need the pending orders listed on the table on the right so that:
a) Only the pending orders are shown
b)...
Hi Guys,
I have these data below and I was thinking of VBA codes where it will create 3 sheets based on Subject.
The 3 Sheets name is based on Subject as well:
Sheet 1 = Math
Sheet 2 = Science
Sheet 3 = History
Each tab has the same header as the raw data. If the subject is math then it will...
Good day,
I need VBA code to automatically insert a row below or inbetween rows based on criteria.
In the example below, I need code to run row by row to check if the "OVER" column >0,
if that case is true, it will check 3 conditions:
1) Check the "HOURS" column for the max hours such as 10.5...
Hi Guys,
Can you possibly help me of how to code for this scenario:
Basically, I need to exclude the data not older than 4 years. However for the computation, the start date is not based from the current date but I want to set the date so a message box will pop asking me what is the starting...
Hi Guys,
I’m looking for a starting point to tackle a problem Iunderstand, but not in enough detail to be really specific…
Basically, I need to simply retrieve or apply calculationsto customer agreement numbers, some of which will have 1 single line of data,simple as I can then just take the...
Hello Excel Gurus,
I was thinking of creating a macro based on below criteria:
5 Tabs will be created in running the macro:
1. New - New accounts that doesn't have any previous data (Copy Whole row)
2. Zero - Accounts that doesn't have any score currently but previously existing (Copy Whole...
Hello Guys,
So I have below data on Sheet1 with a range A4:BC. What if I want to Filter all those that returned as "FALSE" (in T/F Check Column) and copy those related columns namely "Inital Check", "Check', & "T/F Check" on another tab sheet named "Check" in range E1:G1.
<tbody>
A1
-...
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.