masster Wrote:
Hello

Here's the problem I'm asking help from the more Excel experienced
forum users:

I have 7 tables with 4 columns: IP, BytesIN, BytesOUT, BytesTOTAL.
As you already guessed, it's about daily network traffic
(7tables=7days=1week).

I have to output a weekly total report. All would be very simple if for
each daily report I'd have the same IP's, but because my network is
dynamic, one day I can delete an IP or more and another day I can add
one or more.

So i would like to end up with a single table with 4 columns: IP,
SUMofBytesIN, SUMofBytesOUT, SUMofBytesTOTAL, but this table should
have ALL IP's used in that week listed.

Is it possible?

Awaiting for your expert help.
Thank you


Hi Masster

Just a suggestion, instead of 7 tables with 4 columns, have 1 table
with 5 columns, the extra column being the day eg Monday etc or date

You could then get the info you wanted by running a pivot Table


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399297