Hi,
Can someone please help me with an Access or Excel macro/query?
I am trying to autofill some blank fields with account numbers, but I don't know what search terms to look for. I have attached a picture below to show the desired results. I colored the results to show the ranges. I would do it manually, but I have 375 or so accounts and 35,000 lines of data. The problem is that the ranges are varying so there is no set formula.
Thanks,
Neil
