Pelican Parts Forums - Excel or Access Autofill question

Pelican Parts Forums (http://forums.pelicanparts.com/)

- Off Topic Discussions (http://forums.pelicanparts.com/off-topic-discussions/)

- - Excel or Access Autofill question (http://forums.pelicanparts.com/off-topic-discussions/364280-excel-access-autofill-question.html)

Excel or Access Autofill question

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

http://forums.pelicanparts.com/uploa...1188327272.jpg

Forget it. Found the solution here!