Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2015, 07:35 PM
Prath Prath is offline Populate grid from list view Windows 8 Populate grid from list view Office 2013
Novice
Populate grid from list view
 
Join Date: Oct 2015
Posts: 1
Prath is on a distinguished road
Default Populate grid from list view

I am struggling with a grid that *looks like this*

Arrival City 1 | City 2 | City 3 | City 4
Departure
City 1
City 2
City 3


City 4

I need to populate this grid with ticket sale data from another sheet where I have departure and arrival in two different columns and Total amounts for that trip in 3rd column:- (looks like this)
Depart Arrive Total Amt
City 1 City 2 100
City 2 City 3 120
City 3 City 1 90

Kindly help me coming up with a formula to do the same. Thanks
Reply With Quote
  #2  
Old 11-04-2015, 02:30 AM
ufopilot ufopilot is offline Populate grid from list view Windows XP Populate grid from list view Office 2007
Novice
 
Join Date: Oct 2015
Posts: 6
ufopilot is on a distinguished road
Default

will this help?
Attached Files
File Type: xlsm Book1.xlsm (8.9 KB, 11 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA coding for multiple drop-down lists to populate a text box for each list yeatropulo Word VBA 14 11-11-2015 01:08 PM
Populate grid from list view Populate Pulldown list with Macro Samedy Word VBA 1 02-25-2014 06:59 PM
Populate grid from list view MSWord forms use list to populate successive text fields 2surgeons Word 4 03-05-2012 07:19 PM
Populate dropdown list with data from Access table spw4000 Office 0 02-24-2012 05:22 AM
Populate grid from list view List view in calendar. jaycook777 Outlook 5 01-28-2012 07:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft