Hello! This formula is beating me... Cell A25 contains the date 11/7/2019 and Cell B25 contains the date 11/20/2019. I also have the following starting at H2 (H2 contains the date 11/7/2019):
The code below lists the address of all cells in a pre-defined range whose value is zero.
Dim Rng As Range
Set Rng = .Range(.Cells(1, 1), .Cells(1,1000))
Dim ZeroColl As Collection
Set ZeroColl = New Collection
I need to drag this formula down several cells however when I do itchanges the values by 1.
How do I keep the formula “$A1:I20,5,FALSE”intact but change A25 to be A26, A27, A28, etc.,?
Let's say I have a list with orders with every row has seller ID and a product serial nr
So it could be (the name and serial nr are different cells)
So in another sheet I have
John 2 1