My biggest excel brain racker yet...this one isn't simple
 

Ok, I'm trying to make a weekly report and the forms that create the
information for the weekly report to collect for my department.

Right now I'm making the product return form. The weekly report must
sum up all of the product returns done that week, and sum up the types
of returns they are(so we can see that, of the total amount of returns,
this many were "this" type).

That's all to say that the weekly report is gonna have to not only
somehow find out how many returns were completed so that it can add
them up, but also "look" into each completed return to find out it's
type so that that can be summed up on the report too.

Now, I had originally imagined that each return would be saved as a
separate file in a "customer_name+date" file name format (so that if
customer service came looking for a certain return, we could easily
locate it) and somehow I could get excel to count the number of files
in the folder, but then i realized that excel still has to "look" into
those files to see what types of returns they are. And to do that, I
know that you must specify the names of the files to look in, so if I
want the weekly report to automatically gather this information from
different files that wouldn't work cause I'm never sure of the customer
names or dates, so no files can be specified.

Next, I thought, well, if all the returns are on different worksheets
in the same workbook, then I could specify the workbook for the weekly
report to look in, and then it could sum up the types of returns, but
the problem with that is that the product return is to 2 worksheets
long (one form thats filled out, the other sheet is were the data is
transferred to and organized, so that it makes sense and looks nice
when the return is printed out. and there's also a 3rd sheet that has
all the product ID and description info that the second worksheet
references[but that doens't need to be duplicated for each return, just
the first and second worksheets]). Then there's the problem of the
weekly report being able to "count" the number of returns, organizing
the returns in the customer_name+date format, and making it easy to
always print out only the second worksheet of each return.

So, with all that said. what do you all recommend so that the return
form will work with my weekly report. I'm open to any and all
suggestions. I posted this in this forum, becuase i'm sure there will
definately be some serious code needed for this.

Much much thanks in advance for any bit of help that is offered


---
Message posted from http://www.ExcelForum.com/

My biggest excel brain racker yet...this one isn't simple
 

If it's not absolutely necessary to store return data in xl wbs, then use an
Access database. It's easy to record ALL information in tables and with one
SQL you can get all the data you need.

--

Julian Milano


"abxy " wrote in message
...
Ok, I'm trying to make a weekly report and the forms that create the
information for the weekly report to collect for my department.

Right now I'm making the product return form. The weekly report must
sum up all of the product returns done that week, and sum up the types
of returns they are(so we can see that, of the total amount of returns,
this many were "this" type).

That's all to say that the weekly report is gonna have to not only
somehow find out how many returns were completed so that it can add
them up, but also "look" into each completed return to find out it's
type so that that can be summed up on the report too.

Now, I had originally imagined that each return would be saved as a
separate file in a "customer_name+date" file name format (so that if
customer service came looking for a certain return, we could easily
locate it) and somehow I could get excel to count the number of files
in the folder, but then i realized that excel still has to "look" into
those files to see what types of returns they are. And to do that, I
know that you must specify the names of the files to look in, so if I
want the weekly report to automatically gather this information from
different files that wouldn't work cause I'm never sure of the customer
names or dates, so no files can be specified.

Next, I thought, well, if all the returns are on different worksheets
in the same workbook, then I could specify the workbook for the weekly
report to look in, and then it could sum up the types of returns, but
the problem with that is that the product return is to 2 worksheets
long (one form thats filled out, the other sheet is were the data is
transferred to and organized, so that it makes sense and looks nice
when the return is printed out. and there's also a 3rd sheet that has
all the product ID and description info that the second worksheet
references[but that doens't need to be duplicated for each return, just
the first and second worksheets]). Then there's the problem of the
weekly report being able to "count" the number of returns, organizing
the returns in the customer_name+date format, and making it easy to
always print out only the second worksheet of each return.

So, with all that said. what do you all recommend so that the return
form will work with my weekly report. I'm open to any and all
suggestions. I posted this in this forum, becuase i'm sure there will
definately be some serious code needed for this.

Much much thanks in advance for any bit of help that is offered


---
Message posted from http://www.ExcelForum.com/