LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Question Converting entered data into a different output

OK this may be a really stupid question but here goes.

I have a spreadsheet for which I want to set up a form for inputing two parameters which will then automatically generate an output (I have attached to this message a simple example of what I mean).

I am sure there is a way I can do this either in a macro or through some sort of LOOKUP function but I can't quite get my head round it.

Any suggestions (other than where I should put my head!) would be welcome.

Note: I am not really an advanced user of Excel but have done basic Macros and simple LOOKUPs before but this is out of my reach.

Thanks folks
Attached Files
File Type: zip Example conversion.zip (1.8 KB, 34 views)
 
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
Copy data output only to new worksheet. Astroboy Excel Discussion (Misc queries) 5 September 11th 07 11:49 PM
Change data, record output Brian Hahn Excel Discussion (Misc queries) 1 January 15th 07 01:49 AM
bunch of "yes" or "no" entered in row, output 1 if a single yes dan2201 Excel Worksheet Functions 9 September 7th 06 05:05 PM
output date modified if data is entered for multiple rows [email protected] Excel Discussion (Misc queries) 4 October 13th 05 08:09 PM
automatic output from known data lsu-i-like Excel Discussion (Misc queries) 2 June 17th 05 08:22 PM


All times are GMT +1. The time now is 07:28 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"