Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data define and search function request?
All,
I have a workbook with three (3) worksheets in it. The first one is called 'codes' the second one is called 'data', and the third one is called 'output'. In 'codes' there is a list of codes that appear in the data set for example: CODES: ABC BGD JDJ KDK DID In the sheet 'data' the data is in the following format: DATE CODE QUANTITY VALUE 01/01/09 ABC 10 1000 01/01/09 ABC 1 100 01/01/09 KDK 4 44 02/01/09 JDJ 2 13 02/01/09 JDJ 33 22 What I would like to be able to do is as follows: 1) The user is asked to input a date range for example 01/01/09-01/01/09 2) The program then searchs the data for everything in that date range in the 'data' sheet that corresponds to the codes defined in the 'codes' sheet and returns the summed values. For example when the user enters in 01/01/09-01/01/09 the value returned would be: CODE QUANTITY VALUE ABC 11 1100 3) This data would be displayed in the 'output' worksheet. 4) If the User entered the date range 01/01/09-02/01/09 then the following values would be returned: DATE CODE QUANTITY VALUE 01/01/09 ABC 11 1100 01/01/09 KDK 4 44 02/01/09 JDJ 35 35 If anyone could help it would be much appreciated, Regards Joseph Crabtree |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data define and search function request?
Have you considered just using a pivot table?
"joecrabtree" wrote in message ... All, I have a workbook with three (3) worksheets in it. The first one is called 'codes' the second one is called 'data', and the third one is called 'output'. In 'codes' there is a list of codes that appear in the data set for example: CODES: ABC BGD JDJ KDK DID In the sheet 'data' the data is in the following format: DATE CODE QUANTITY VALUE 01/01/09 ABC 10 1000 01/01/09 ABC 1 100 01/01/09 KDK 4 44 02/01/09 JDJ 2 13 02/01/09 JDJ 33 22 What I would like to be able to do is as follows: 1) The user is asked to input a date range for example 01/01/09-01/01/09 2) The program then searchs the data for everything in that date range in the 'data' sheet that corresponds to the codes defined in the 'codes' sheet and returns the summed values. For example when the user enters in 01/01/09-01/01/09 the value returned would be: CODE QUANTITY VALUE ABC 11 1100 3) This data would be displayed in the 'output' worksheet. 4) If the User entered the date range 01/01/09-02/01/09 then the following values would be returned: DATE CODE QUANTITY VALUE 01/01/09 ABC 11 1100 01/01/09 KDK 4 44 02/01/09 JDJ 35 35 If anyone could help it would be much appreciated, Regards Joseph Crabtree |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data define and search function request?
Have you considered just using a pivot table?
Ross "joecrabtree" wrote in message ... All, I have a workbook with three (3) worksheets in it. The first one is called 'codes' the second one is called 'data', and the third one is called 'output'. In 'codes' there is a list of codes that appear in the data set for example: CODES: ABC BGD JDJ KDK DID In the sheet 'data' the data is in the following format: DATE CODE QUANTITY VALUE 01/01/09 ABC 10 1000 01/01/09 ABC 1 100 01/01/09 KDK 4 44 02/01/09 JDJ 2 13 02/01/09 JDJ 33 22 What I would like to be able to do is as follows: 1) The user is asked to input a date range for example 01/01/09-01/01/09 2) The program then searchs the data for everything in that date range in the 'data' sheet that corresponds to the codes defined in the 'codes' sheet and returns the summed values. For example when the user enters in 01/01/09-01/01/09 the value returned would be: CODE QUANTITY VALUE ABC 11 1100 3) This data would be displayed in the 'output' worksheet. 4) If the User entered the date range 01/01/09-02/01/09 then the following values would be returned: DATE CODE QUANTITY VALUE 01/01/09 ABC 11 1100 01/01/09 KDK 4 44 02/01/09 JDJ 35 35 If anyone could help it would be much appreciated, Regards Joseph Crabtree |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data define and search function request?
Yes I had considered it. But I wanted to use a more automated method. Or would you suggest that I automate the pivot table using VBA? Thanks Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search request | Excel Discussion (Misc queries) | |||
search in define name window | Excel Programming | |||
dynamic search in the Define Name window | Excel Discussion (Misc queries) | |||
Find/search function/example request. | Excel Programming | |||
search for values to define range | Excel Programming |