Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating sveral reports from one excel file
Hi Am not sure if this is possible in Excel, so any advice would b great! I have several worksheets that come from customers every day. The look kind of like this: Code CUSTOMER SITE Identifier ABCD EG1 31234 ABCD EG1 34343 ABCD EG1 65575 EFGH EG2 54354 EFGH EG2 45445 IJKLM EG3 43545 The problem I have is that each of the codes relate to a specific sit and I want to produce a report just relating to those sites (codes) i exclude the data relating to the other codes. I currently have several macro's that can do this but I have had to create a macr specific to each client, which then produces the reports from the cod numbers. This is OK but we have lots of clients and hence lots o macros as I programme say customer X will have these site codes and t print for codes EG1 then EG2 and then EG3. What I would like is t consolidate this whole process into one Macro. What I would like to happen is to open the Excel file from the custome and somehow Excel realises the first 3 rows are code ABCD, and quer another file to verify the name of the customer (I have a file of al codes and which sites this relates to), produce a report for this site go back to the original file and do the same for EFGH and so on. Thi way, it would prevent the need for hundereds for each client. An ideas? Darre -- DGillha ----------------------------------------------------------------------- DGillham's Profile: http://www.excelforum.com/member.php...fo&userid=1370 View this thread: http://www.excelforum.com/showthread.php?threadid=47981 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Spreadsheet Reports | Excel Discussion (Misc queries) | |||
Excel 2007 creating reports for diffrerent products one at a time | Excel Discussion (Misc queries) | |||
Creating Reports from Excel data to Word | Excel Discussion (Misc queries) | |||
Creating reports that grow/shrink | Excel Discussion (Misc queries) | |||
Creating Customize Reports | Excel Discussion (Misc queries) |