| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data collation killing me!!
Ok...no answer to my last post so I will try again..... I have a data page (10 of them in fact identical except the tab names), each of these has Column A as a description, Column B as subtotals of each division and columns C through to Z as the date. I then have the unenviable task of trying to collate the data from dropdown boxes that the user selects the item number from, tabs to column C and types in the number purchased. Column B subtotals along the way. How oh HOW can I do this three dimensional task as all 10 sheets need to be collated into ONE report??????? Please anybody got any ideas?? I've tryed VLOOKUP, HLOOKUP, MATCH but they will only look at one single line...and the item may have been used between two dates......and they both need to be individual as at the month end, the report uses dates to and from to calculate the usage..... Gosh I'm even confusing myself now!!! Thanks Sandi -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=564594 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data collation killing me!!
Can you post an example ?? -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=564594 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data collation killing me!!
umm...not sure how else to do it but ok... Column A5:A20 Item Code Column B21 Subtotal of items (changes as the dates changed and item used) Column C1 through to Column Z1 is where the user enters the date the item was used C100 Through to C150 is the NUMBER the user enters the times the item was used..... This is repeated on 10 different sheets for different Months I then need to report on the Item number and the number of times it was used between two dates. (a start and finish date.) Does this make more sense? Sandi -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=564594 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data collation killing me!!
...As I still have a problem visualising the data, can you post a sample w/book?
What's in columns C2 to C99 for example (may not be relevant but the layout appears "strange" to me)? "rhani111" wrote: umm...not sure how else to do it but ok... Column A5:A20 Item Code Column B21 Subtotal of items (changes as the dates changed and item used) Column C1 through to Column Z1 is where the user enters the date the item was used C100 Through to C150 is the NUMBER the user enters the times the item was used..... This is repeated on 10 different sheets for different Months I then need to report on the Item number and the number of times it was used between two dates. (a start and finish date.) Does this make more sense? Sandi -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=564594 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data collation killing me!!
Ok...here's kinda what it looks like +-------------------------------------------------------------------+ |Filename: Testin.doc | |Download: http://www.excelforum.com/attachment.php?postid=5089 | +-------------------------------------------------------------------+ -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=564594 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data collation killing me!!
Sorry to be pedantic but I was hoping that you could give me (us!) a sample
WORKBOOK with good data coverage and (even better) include a sample of the expected output. "rhani111" wrote: Ok...here's kinda what it looks like +-------------------------------------------------------------------+ |Filename: Testin.doc | |Download: http://www.excelforum.com/attachment.php?postid=5089 | +-------------------------------------------------------------------+ -- rhani111 ------------------------------------------------------------------------ rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940 View this thread: http://www.excelforum.com/showthread...hreadid=564594 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Hybrid Mode
