I have a spreadsheet that have pay period dates, that run from V5 to AT5. We have the past pay months within 1 month grouped together and the future months within 1 month grouped together. For instance this month is August, so all the columns with dates in July, August, and September are not...
Is there a way to only copy certain columns from an auto filter?
With the below example the active sheet has 8 columns of data G, L, P, R, S, T, W, AB (other columns have been hidden)
When I copy the data, I don’t want to copy column W & AB so that only 6 columns of data will be moved to...
Hello!
I've searched high and low across multiple forums for this specific answer, but I can't seem to find it based on cell value. I can find the VBA code for ALL worksheet names to be listed in the ListBox, but not specific ones based on cell value to be used as selections for printing...
Hi, trying another range, and for some reason it's not pulling all the details.
Set WBrng = Range("A1", Range("J" & Rows.Count).End(xlUp))
WBrng.Copy
it's only displaying A1-J1. I'd like the last row to be dynamic in the event it goes longer than 9 rows:
sample data:
Header
Header...
hi! I have a sheet which contains content in cells A1:H3, row 4 & 5 is blank, and row 6 starts a new table A6:H9.
I was trying to declare a range for A1:H last. In the event the top table 1 row, or 2, or 3, I wanted to have the range select the last row. doesnt appear to be working properly...
Hi, I'm wanting to count the number of 'Yes' values in columns B and C, but only count the 'Yes' values after the last entry in column D for the associated location.
In the attached example, for Kettering the count should result in 1, as there is only 1 'Yes' in columns B and C if we count...
I am using the following for a macro:
Dim y As Long
For y = 1 To Cells(Rows.Count, “AK”).End(xlUp).Row
If Range(“AK:AM” & y).Value = “DRUG REQUIRES PRIOR AUTHORIZATION” And Range(“A” & y).Value = “” Then
Range(“A” & y).Value = “PA REQD”
End If
Next y
However, I keep getting an error...
Hi Mr Excel,
How to get result in Column Q & S?
Given number of range to check for Column Q in M , Column S in O
The Range to check in Column G.
Example : Cell O6 show 2 number of range , then check how many value < -0.6 in Column G and the result is 1 in Column S.
Same goes to Column M for...
Hello. I need a formula that looks for the value in a cell and compares it to a range of cells to throwback if there is a match anywhere in the range of cells. I would also like the formula to exclude considering blank cells so I do not end up with false No Matches. Example of the data is below...
Hi all,
I am trying to find the way to obtain the minimum value from a range, with some conditions.
So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...
Is there a way in excel to have a select range of columns in a row following a reference cell?
Situation: I have a set range that is part of a data pull and populates information off a reference ID# that I pull in from a data set. The downside is that I have some manual cells that I use for...
Hello,
I’m not sure this is the best way to go about it..
But I need code to get a specified range in a macro. The range is variable .. so I’m trying to use keyboard shortcuts like “ctrl + home” and “ctrl + end” to get the correct range.
The problem is when I start let’s say at the bottom...
Situation: I have this VBA code that logs any change that is made in the excel sheet and that great; but i need it modified. The plan is to use this in one column as a master change log. But i need a sepret one that will log the window user ID / DATE / Time and lock it to the ROW they edited. So...
I found this by Snakehips and it was VERY helpful ! I tried to modify it but found that it only works with numeric entries and not alpha numeric entries.
Rich (BB code):
Sub Fill() [A4] = [A1].Value
ato = [B1].Value
[B4] = [A2].Value
bto = [B2].Value
[C4] = [A3].Value...
Hi,
I really hope someone can help me make this drop down list.
I have a cell that a user will type in a acronym. Cell B1
I have a range of acronyms in a separate tab (about 700 of them).
I would like the user to presented with a drop down list of cells within the range that contain those...
I have part of my code below and it requires a little tweaking.
Breakdown: I have two worksheets, one called PivotTable and another called PerC. In my PivotTable worksheet, there is a value in Q2 that generally changes every month. I want it to go through column J and find any values that are...
Hi all,
I need your advice if possible.
I have a dataset which i am trying to determine between blank rows with variable blocks of data ranges in Column R to see if the numerical values are the same within the range and if the value are the same I want "True" and where its not exact "False"...
Hi,
I want to look up a number that is in column D from column E, and if it is found in a table on a different tab in column A rows 9-109 put the work 'Expenditure' in the lookup cell in column E, and if the number found from the lookup is in column A rows 121-160, put 'Income' in the lookup...
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.