Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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)
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Creating a data entry form in excel

This isn't a binary group, so attachments aren't permitted. If you upload
your file to a website, you can post a url here, but many readers will be
reluctant to read files from unknown sources.
--
David Biddulph

"Seaside Nutty" wrote in message
...

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

I have a spreadsheet for which I want to set up a data entry form (I
will try to attach to this message)

--
Seaside Nutty



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
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 10:30 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"