LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
skinny
 
Posts: n/a
Default Central Address Database

If anyone can help me with this one, it would be greatly appreciated.

I'm trying to create a central spreadsheet that can be accessed by all users
on our network for client address & shipping details etc
I have a central sheet with customer code(4 digit code) in A1 and address
details in B1.
When creating hundreds of seperate spreadsheets there is a cell where you
can enter this 4 digit code (e.g F10)
When this code is entered into F10, another field (F11) must read the
details of field B1.
Is this possible?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MIN Function w/ variable address reference WLMPilot Excel Worksheet Functions 7 June 10th 05 07:56 PM
Construct address as a reference not "text" aka_norm Excel Worksheet Functions 2 May 28th 05 10:42 PM
The Template Wizard retains the original location for my database Packwood Excel Discussion (Misc queries) 0 April 15th 05 05:25 PM
How do I import Office address book to Outlook Express address bo. snnorp Excel Discussion (Misc queries) 2 February 22nd 05 11:47 AM
Graphing Database Growth Rate DavidM Charts and Charting in Excel 1 February 2nd 05 12:01 AM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"