cell referance

I would like to execute a script (macro) that would search a spreadsheet and return the cell reference if: Cell value = Home or Buy or Rent So my array results would be for example: A16 Z22 R100 B210 Would be even better if besides the cell references, I could see the value of the cell...

Hi everyone, I seem to be having an issue updating a cell reference when new data is added to table. I have built a little summary section in my workbook to display various information like Sales, Profit, etc… I have multiple summary charts to show different years. This summary sits by itself...

This macro may not be set out correctly/efficiently but it works so i didn't dare change it. I recorded it and didn't impute to much manually. Basically I change the dates daily which is fine but I was thinking is there a way to loop the macro changing the cells highlighted in bold after each...

Hello guys, first post here on MrExcel. I'm a proficient Excel user with several years of experience but completely new to VBA and I believe my current problem can only be solved with VBA. I looked the web for hours, but every question was case specific and I couldn't adjust their solutions to...

Hi, I'm currently trying to write the cell ref of a vlookup (M2) i've used in the cell next to it N2. This is the formula i've used for the lookup. =VLOOKUP(F2,AxTable1[[VPN]:[Item VAT]],1,FALSE) The idea of what im doing is bringing back an item number and then i need to bring back a...

Hello all youVBA geniuses, Need some help with a doozy of a code here. I've got this pieceof script that hides rows in a tab called "Lab Tests_Plants". Youenter a number in cell D15 and it shows you the corresponding amount of rows.Cell E15 = "#" and E16 = "<=" to lay out parameters. Private...

Hey Experts I need your help. I have to create a financial statements for set of years. We know that closing balance of particular year becomes opening balances of next year, so we link the closing balance of last year to opening balance of new year in new sheet. When we are done with creating...

The following is just part of my code. i am getting an Error 9: Subscript out of range. I've tried a few things in order to correct this but nothing seems to change it. r = 2 c = 2 i = 2 LastRowNumber = xlLastRow(Sheets("Data")) Do While...

Can you write a formula where the function you want to use is a variable (cell ref)? I’d like to be able to change the function in a formula from a cell reference. Ex. =max (A2:A3), where the function “max” is defined from a cell reference in cell A1, so I can change the function to min, sum...

I have a table that can be sorted with formulas that reference rows above/below a formula. As I sort the table, using absolute references or not, I cannot get the formulas to stay with the correct row as it is sorted. I also have formulas in the row that refer to other columns of that row so the...

Hello, I am trying to automate a footnote for a report. Here are the conditions: If cell O13 does not equal 1, I want cell B39 to display the following text (including asterisk): **O13 denials are included in the table below. Where the value of O13 is displayed. If cell O13=1, I want cell B39...

I have a Master Sheet that is doing a VLOOKUP and pulling information from another sheet that I plan to download daily. The downloaded sheet is something that I will save daily in the same location and save as "VLOOKUP(.....filenameMMDDYY.xlsx...)". Every day I plan to update the formulas so...

I want to copy a formula from a cell to another cell but when I copy the formula the cell references change. Can I copy the formula without changing the cell reference? Here is an example: =(SUMIFS('VSAT Site Availbility Week #17'!L3:L600,'VSAT Site Availbility Week #17'!D3:D600,"=Transit_2nd...

Hi All I have a table and I need it to filter on the basis of a value entered in a different cell - but i want it to show all rows greater than and equal to that specific value. Sub Testmacro() filtercriteria = Range("H3").Value Sheets("Report 1").ListObjects("Table1").Range.AutoFilter _...

Hi everyone, <o:p></o:p> <o:p> </o:p> I'm looking for a function that will find a value somewhere in a column and then return the row reference. From two row references obtained, i then need to use them as my data range to calculate average values for a different column.<o:p></o:p> <o:p> </o:p>...

I am trying to figure out how to "code" this problem using a formula I have 1 input value in A1 ex 333,000 Want to check it against this matrix Columng A <TBODY> Column A Column B Column C <= 200,000 +10% <= 300,000 +5% >= 400,000 -5% >= 600,000 -10% </TBODY> Think...