Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use a worksheet as a form to collect data
Is it possible to use a worksheet as a form to collect data for example, we
have monthly reviews, where we enter data into cells of an excel spreadsheet (this is full of Validation and Conditional Formating) so January 2007 would be selected from a drop down list, as would the Company who's review was taking place. A "once a month date" is entered as the date the review takes place. What I would like to do (without creating 12 worksheets) is to colate this data, into a (hiden) worksheet so that I can use this to calculate "year to date" figures and for comparison previous years figures and use the main input form to recover a previous reviews data. I supose what I am after doing is similar to a Access input form writing to and reading from an Access table, but in excel. Is this possible??? Thanks in anticipation Paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use a worksheet as a form to collect data
You may want to look at Debra Dalgleish's site:
http://contextures.com/xlForm02.html And maybe later... http://contextures.com/xlForm03.html Paul Kinnear wrote: Is it possible to use a worksheet as a form to collect data for example, we have monthly reviews, where we enter data into cells of an excel spreadsheet (this is full of Validation and Conditional Formating) so January 2007 would be selected from a drop down list, as would the Company who's review was taking place. A "once a month date" is entered as the date the review takes place. What I would like to do (without creating 12 worksheets) is to colate this data, into a (hiden) worksheet so that I can use this to calculate "year to date" figures and for comparison previous years figures and use the main input form to recover a previous reviews data. I supose what I am after doing is similar to a Access input form writing to and reading from an Access table, but in excel. Is this possible??? Thanks in anticipation Paul -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use a worksheet as a form to collect data
Hi Paul,
To do that automatically you will need to add a macro (VBA). The basic idea is to copy all the data from the input sheet to the master database sheet below the last set of data. Viewing prior data on the input sheet could also be done with a macro which executes the Data, Filter, Advanced Filter, Copy to a New location command. -- Thanks, Shane Devenshire "Paul Kinnear" wrote: Is it possible to use a worksheet as a form to collect data for example, we have monthly reviews, where we enter data into cells of an excel spreadsheet (this is full of Validation and Conditional Formating) so January 2007 would be selected from a drop down list, as would the Company who's review was taking place. A "once a month date" is entered as the date the review takes place. What I would like to do (without creating 12 worksheets) is to colate this data, into a (hiden) worksheet so that I can use this to calculate "year to date" figures and for comparison previous years figures and use the main input form to recover a previous reviews data. I supose what I am after doing is similar to a Access input form writing to and reading from an Access table, but in excel. Is this possible??? Thanks in anticipation Paul |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use a worksheet as a form to collect data
Sorry for taking so long to thank you, but I just had to get this right.
Thanks Dave you are "the main man" Best regards Paul "Dave Peterson" wrote: You may want to look at Debra Dalgleish's site: http://contextures.com/xlForm02.html And maybe later... http://contextures.com/xlForm03.html Paul Kinnear wrote: Is it possible to use a worksheet as a form to collect data for example, we have monthly reviews, where we enter data into cells of an excel spreadsheet (this is full of Validation and Conditional Formating) so January 2007 would be selected from a drop down list, as would the Company who's review was taking place. A "once a month date" is entered as the date the review takes place. What I would like to do (without creating 12 worksheets) is to colate this data, into a (hiden) worksheet so that I can use this to calculate "year to date" figures and for comparison previous years figures and use the main input form to recover a previous reviews data. I supose what I am after doing is similar to a Access input form writing to and reading from an Access table, but in excel. Is this possible??? Thanks in anticipation Paul -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use a worksheet as a form to collect data
Glad it worked.
Paul Kinnear wrote: Sorry for taking so long to thank you, but I just had to get this right. Thanks Dave you are "the main man" Best regards Paul "Dave Peterson" wrote: You may want to look at Debra Dalgleish's site: http://contextures.com/xlForm02.html And maybe later... http://contextures.com/xlForm03.html Paul Kinnear wrote: Is it possible to use a worksheet as a form to collect data for example, we have monthly reviews, where we enter data into cells of an excel spreadsheet (this is full of Validation and Conditional Formating) so January 2007 would be selected from a drop down list, as would the Company who's review was taking place. A "once a month date" is entered as the date the review takes place. What I would like to do (without creating 12 worksheets) is to colate this data, into a (hiden) worksheet so that I can use this to calculate "year to date" figures and for comparison previous years figures and use the main input form to recover a previous reviews data. I supose what I am after doing is similar to a Access input form writing to and reading from an Access table, but in excel. Is this possible??? Thanks in anticipation Paul -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Form used in another worksheet | Excel Discussion (Misc queries) | |||
Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |