cell reference help

Hello, I am trying to compare 2 lists of data, column a (current data) and column b (new data), and find the address of the cells that are in column b and not column a. The data in column a is constant and the data in column b is updated regularly. Example: What formula would I use to find the...

I hope this isn't a duplicate question; to describe what I'm trying to do keeps getting so detailed that searches aren't very effective. Please feel free to point me in the right direction if this has already been asked and answered. I'm working with a book that has one sheet at the front...

Trying to reference a cell using vlookup in vba, this way I can offset from the cell and paste data from a userform text box. Heres what I thought may work, but it didnt. Thoughts? Dim acell As RangeSet acell = Application.VLookup(Val(TextBox1.Text), Sheets("thesheet").Range("a1:d42"), 1...

how do I reference value of a cell in VBA example.. Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select ActiveSheet.Range("$A$1:$XFD$10000").AutoFilter Field:=2, Criteria1:= _ "NAME" I want to replace hard coded "NAME" with the contents of a cell in another sheet?

Good evening, I have run an INDEX and MATCH formula to give me a resultant cell reference number. I now want to copy a cell to this specific cell reference using another formula. For example the data I want to copy is in cell A1 and in cell A2 I have the result of the index formula (B1). I...

Hi, I'm new to using macros and VBA in excel. I am trying to store data in another worksheet but it does not automatically move to the next column. I want to store incrementally to the right of the last column with data on the second sheet. my macro code below as follows: === Sub Macro6() '...