Copying Items from Worksheets to a "Sumation Sheet"?

[turner2000]

Hey Guys,

Hoping you can help with this little problem of mine.

I have set up a spreadsheet for work that tracks orders each day of th
week but we have to produce a weekly sheet that includes everything fro
the daily sheets. On each daily sheet I have 15 available rows fo
different customers but not all of these are filled each day.

I want to be able to copy the information from the rows that contai
information each day into one worksheet for the week. Is this possibl
to automatically ignore the blank rows and just copy information int
the weekly worksheet.

Also the rows aren't completely blank as in some columns I have som
combo and tick boxes but if say column A is empty I want that ro
ignored.

Hope you understand what I mean as my explanation probably isn't to
good.

Thanks in advance!

-turner200

 

[Arvi Laanemets]

Hi

I'd use the design, where all input is done on single sheet - with date
entered into one column. And would add 2 report sheets - a daily report,
where user can select a day from dropdown list, and weekly report - a fixed
one when workbook is used for a week only, or also with dropdown for
selecting the week, when the same workbook is used to enter data for longer
data interval (when this is the case, there would probably be also monthly
or even yearly reports).

This way you'll have a simple database, which allows you some additional
analysis, p.e. you can create reports where you can select customer and
display summary data for selected customer for some time interval, or/and
have displayed such info on graph(s), or you can comparise different
customers, etc.


Arvi Laanemets