#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default If Then populate

Good day i am struggling here and need some help fast, i am trying to
populate some cells with data based on certain conditions. If i select
certain Project via drop down menu i want the work sheet to be populated with
data only relative to that Project.
Can anyone help me please with example????
Thanks a million
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default If Then populate

Your description is pretty vague, but a suggestion...

Say your dropdown is in cell A1 of sheet1 and your project data table is
in Sheet2, columns A:J, with the project name in column A (which you
could then use as the list for your dropdown, if you wanted).

Then in Sheet1, enter:

B1: =VLOOKUP(A1,Sheet2!$A:$J),2,FALSE)
C1: =VLOOKUP(A1,Sheet2!$A:$J),3,FALSE)
....
J1: =VLOOKUP(A1,Sheet2!$A:$J,10,FALSE)

Change references to suit.

In article ,
whatzzup wrote:

Good day i am struggling here and need some help fast, i am trying to
populate some cells with data based on certain conditions. If i select
certain Project via drop down menu i want the work sheet to be populated with
data only relative to that Project.
Can anyone help me please with example????
Thanks a million

Reply
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
VB Macro to Populate Row from J30 KCG Excel Discussion (Misc queries) 0 August 30th 07 03:46 AM
Populate a form Doug Excel Worksheet Functions 3 December 15th 06 03:33 PM
Populate y col from x col values aquaflow Excel Discussion (Misc queries) 2 November 8th 06 09:37 PM
Auto populate with value chris.howes Excel Discussion (Misc queries) 1 June 9th 06 06:33 PM
auto populate jdog Excel Discussion (Misc queries) 4 October 21st 05 11:51 PM


All times are GMT +1. The time now is 04:26 AM.

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"