Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-23-2014, 01:55 AM
ekeithjohnson ekeithjohnson is offline Formulas/Scripts That Cross Reference & Import Data Windows 7 32bit Formulas/Scripts That Cross Reference & Import Data Office 2013
Novice
Formulas/Scripts That Cross Reference & Import Data
 
Join Date: Aug 2014
Posts: 12
ekeithjohnson is on a distinguished road
Question Formulas/Scripts That Cross Reference & Import Data

I am not a frequent user of Excel and I have never used a macro to perform certain functions but I have a project that likely could use a macro to achieve what I desire.

Can column code data be cross referenced to a master list to display the description of the code? For example, data in a column is a facility code. I have a separate master list of all facility codes. Can a formula/script be written that takes the facility code then goes out and cross references the code in the listing and import the facility name in a new column? Similarly, another column contains data that is an operation code. I have a separate list of all operation codes. Can a formula/script be written that take the code then goes out to the listing cross referencing it and imports the code description back into another new column? In another column I have a tracking number is unique for each record and would be the link in the records.

Is this possible to achieve in Excel without an enormous amount of work?

Thanks.

Keith
Reply With Quote
  #2  
Old 08-23-2014, 02:00 AM
ekeithjohnson ekeithjohnson is offline Formulas/Scripts That Cross Reference & Import Data Windows 7 32bit Formulas/Scripts That Cross Reference & Import Data Office 2013
Novice
Formulas/Scripts That Cross Reference & Import Data
 
Join Date: Aug 2014
Posts: 12
ekeithjohnson is on a distinguished road
Question Search & Import Function

I am an infrequent user of Excel but I have a project I am working on and I am curious if certain functions can be run through a formula/script.

I have a spreadsheet that has multiple rows of downloaded processing activity dates and times. Is it possible to write a formula/script for a record that goes out to this spreadsheet and finds the last processing date and time (along with other descriptive data) and imports it into another section of my spreadsheet?

Thanks.

Keith
Reply With Quote
  #3  
Old 08-23-2014, 12:08 PM
charlesdh charlesdh is offline Formulas/Scripts That Cross Reference & Import Data Windows 7 32bit Formulas/Scripts That Cross Reference & Import Data Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Keith,

Can you attach a copy of your file so we can see. It would help.
But, you should probably use "Access".
And, too it could be done in Excel
Charles
Reply With Quote
  #4  
Old 08-23-2014, 11:26 PM
macropod's Avatar
macropod macropod is offline Formulas/Scripts That Cross Reference & Import Data Windows 7 64bit Formulas/Scripts That Cross Reference & Import Data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

This is quite easy to do using Excel's LOOKUP function or combined INDEX/MATCH functions. See, for example: https://www.msofficeforums.com/excel...ting-data.html. No programming required.

PS: I've merged your two threads as both issues can be handled in much the same way.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas/Scripts That Cross Reference & Import Data Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
Cross-reference problem Marineboy Word 2 08-05-2011 03:37 AM
Formulas/Scripts That Cross Reference & Import Data Cross-reference in two lines!!!!! Jamal NUMAN Word 3 04-12-2011 06:47 AM
2 figures cross reference mmdmov Word 0 05-05-2010 09:12 AM
How do I return from a cross reference? smoggymark Word 0 10-21-2008 07:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:33 AM.


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