I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...
Is there a code that will allow me to use a button to go to a cell by matching the value of a list of values cell with the values in column D. When I choose option “Apple” from the drop down and click the button, the code searches column D and locates the cell with “Apple” and goes to that cell...
Been searching the interwebs for an answer to how I might hyperlink to a cell where an IF statement is true.
I have a worksheet with 100's of columns with dates in them and then on the row above the following formula =IF(BP4=TODAY(),"TODAY","").
When tomorrow it arrives BQ4 will...
I have a current Macro that finds a date....
Dim i, lr As Integer
lr = ActiveSheet.Range("A65536").End(xlUp).Row
For i = 3 To lr
If Cells(i, 1) = Date Then
However I have a spreadsheet that I need to...
I require urgent help. Can anyone please help me for the following problem:
I have an excel sheet for data entry (month wise)
it has 5 columns per day. and 150 products
so it is tiring to scroll every time to reach a particular date.
thus can anyone help me with a simple formula so that i...
I am working on a sheet with 100+ rows of data, each row representing a different size of widgets. I have a cell at the top - Q1 - where you can enter the size widget you are looking for and, using conditional formatting, the row(s) containing that size widget will turn yellow with bold text...
I need to take the data from formula (a numeric value) and use this to automaticly move the cursor to a specific cell which is based on this result. IE in simple terms Formula (2*300) gives a result of 600, I need to then move to cell A600, if result is 150 then I need to move to cell A150...