Pelican Parts
Parts Catalog Accessories Catalog How To Articles Tech Forums
Call Pelican Parts at 888-280-7799
Shopping Cart Cart | Project List | Order Status | Help



Go Back   Pelican Parts Forums > Miscellaneous and Off Topic Forums > Off Topic Discussions


Reply
 
LinkBack Thread Tools Rate Thread
Author
Thread Post New Thread    Reply
Registered
 
Join Date: Feb 2000
Location: Dallas, TX
Posts: 4,612
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


__________________
Neil
'73 911S targa
Old 08-28-2007, 10:55 AM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #1 (permalink)
Registered
 
Join Date: Feb 2000
Location: Dallas, TX
Posts: 4,612
Forget it. Found the solution here!

__________________
Neil
'73 911S targa
Old 08-28-2007, 11:44 AM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #2 (permalink)
Reply


 


All times are GMT -8. The time now is 02:26 PM.


 
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website -    DMCA Registered Agent Contact Page
 

DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.