specific

I'm sure this is really easy but I can't figure it out - I'm trying to find the last cell in column A that has a specific value. I currently have this, which gives me the value that I want, (in column B), but I need to now do it with criteria; Range("J3").Value =...

Good Morning All, I have searched Google long and hard for an answer to this question to no avail!! I need to copy a CSV file from a specific directory, and make it available to the clipbaord, so I can paste it later using ctrl + v. I have developed a Macro that manipulates an XLSM file then...

I have a long list of stock option strikes, 130 in all. When the stock price moves up or down beyond the number of rows I can see in my display, is there a way to automatically center the display based on a specific cell (at-the-money strike)?

Hi all, I need some help fixing this code. Worksheets("Sheet1").Range("A6:A167").Locked = FalseWorksheets("Sheet1").Range("C6:C167").Locked = False ActiveSheet.Protect Password:="abc" I am trying to lock those specific ranges, but it keeps throwing an error every time I try to implement it...

even if I use a report filter..I noticed that when I try to filter further via the pivot items ...I still see all the data even though I filtered vis the report filter ....is there way to make the pivot filter out the data accordingly ? eg I use report to filter for today's date but when I...

Hello, I have a worksheet with various dollar amounts in multiple cells. I would like to come up with a VBA Code to increase specific cells (B14, C14, D14, B15, C15, D15) by a percentage that is set by a cell value (cell A1). Any help would be greatly appreciated!

Hi all, I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per...

I am struggling with creating a formula that works for the below scenario <tbody> A B C 1 Item Budget v1 Budget v2 2 Item A 50 55 3 Item B 60 65 4 Item C 70 75 5 Item D 80 85 </tbody> I have two sheets in one workbook. One with full budget data with in this scenario a Budget v1...

I am trying to create an averageif formula but rather than for a range, a specific set of cells: A1, A5, A7 I thought it would be as follows: =averageif((A1, A5, A7), "<>")) But this returns #Value! Any advice or help would be much appriciated. Iain.

We have a shared spreadsheet that tracks requests from customers - When a request has been filled, a value is inputted into a specific cell in that row...I'd like to try and find VBA that could send an email to that employee when one of their requests has been updated. I've included example...

Hello all, So in column M on sheet 1 I have data that is in no specific order and the amount is always chaning. The data is Dog, Cat, and Fish. On Sheet 2 starting in A1 going to A3, I have Dog, Cat, and Fish in their own columns. They each have a specific cell color and font color. I want...

Is there any way to stop excel from opening subsequent workbooks at the size and or location of the last opened workbook? I wrote a script to open a specific set of data at a specific location and size. I keep this open all day but every time I open anew workbook it snaps to that size/ location...

So, I have a code that combines ALL worksheets and puts them in a combined worksheet. I just want to combine specific worksheets called 'US Data' and 'Canada Data' and not combine the rest of the worksheets I need to add - this is the code I have, do I need a new code or.... ? Any help would be...

I need a formula to sum the values in a series of cells where the cell to the left is a specific number and the cell to the right is a different specific number. Any help would be much appreciated.

Hi I have a worksheet tracking sales reviews. I want to copy specific cells from that worksheet to a sheet in another workbook depending on whether or not a given cell in the first worksheet contains the letter Y. The first worksheet will be looked at by me every Monday and I would like any new...

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...

Hi Friends, I have a list of data where I have 2 drop Down based on Region and Name. Is there any possibility that Only the Specific User can access his own specific data. I don't want them to view the complete list. Regards Rahul Nair

If Cell B1 contains specific text, example "In", how to have it automatically ClearContents of Cell A1? would like to make this work for a range of cells if G3:G12 contain the word "In" then have them clear the corresponding C3:C7. Is this possible through Conditional formatting or is a Macro...

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...

Hi all, On a specific sheet (for example "sheet ABC") in a specific workbook (for example "Workbook ABC"), I have formulas in the columns D, E, G, J and I. Is there a possibility, when inserting row(s), to automatically copy the formulas down in the inserted rows in the specific columns? Thanks!