Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 22nd, 2006, 06:46 AM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Autoupdate multiple information

I have an excel sheet which contains details of several ships such as fuel consumption, speed, tons, no. of cranes etc. based on which I have to perform certain calculations. The above details are entered into the sheet manually inorder to calculate the maximum amount of cargo that I can load on that ship. So, at the top of the sheet I made a drop down list of the names of all the ships. I am trying to make all the data underneath to change to their respective ships' particulars based on the selection at the top.

I would appreciate if someone could help me with this.

Thanks

Ihsan

Reply With Quote
  #2 (permalink)  
Old February 22nd, 2006, 08:11 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 173
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Ihsan,

This is a fairly standard modelling exercise. Thae basics of which are to have an input sheet (could be multiple input sheets but we don't want to confuse the example) which is a block table of information on every ship. It should look something along the lines of:

ID Ship Name Speed Tons ...
01 Bravo 10 1000 ...
02 Delta 20 1500 ...
03 Tango 50 50000 ...
...

depending on what data you've got. Then on a separate calculation sheet you want to pull information for a specific ship off the table. The best way to do this is to have a couter input cell at the top of the calculation sheet which can be set to a number. Then below the counter input cell you pull the set of information for any one ship through by using a series of INDEX formulae. i.e. to get the Ship Name you'd type the following formula (assuming the input table was the above demonstrated table and was found on cells A1:D4 of sheet Inputs and that the counter cell was in cell A1 of the current sheet) :
Code:
=INDEX(Inputs!A1:D4,$A$1+1,2)
With this method you can dynamically pull through the inputs for any one ship by amending the counter cell and these one-ship specific set of inputs can then be linked up to a set of ship specific calcs to give whatever answer you need for particular ships.

Hope this helps,
Maccas

Reply With Quote
  #3 (permalink)  
Old February 23rd, 2006, 07:40 AM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks a bunch! That really helped.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple workgroup information file dilemna Bob Bedell Access 4 January 7th, 2006 03:53 AM
Importing Multiple files in Multiple tables Versi Suomi Access 6 June 1st, 2005 08:47 AM
Multiple ADO multiple user login Oracle9i jhay0721 Pro VB Databases 1 April 4th, 2005 11:23 AM
Multiple Joins in Multiple Table Search query pookster Access 4 September 23rd, 2004 03:04 PM
Updating multiple Rows from multiple fields in ASP vdm_nana SQL Server ASP 0 April 1st, 2004 04:26 AM



All times are GMT -4. The time now is 10:44 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.