What you describe isn't difficult I wouldn't think - but I wouldn't see
every entry requiring a new row on one of the 4 sheets - it seems like some
of the existing rows would need to be updated - but then maybe you are
storing transactions and not maintaining a balance. So in either case it
wouldn't be difficult, but would probably be involved - so not being
difficult doesn't mean it wouldn't take substantial work.

--
Regards,
Tom Ogilvy



"Brian" wrote in message
...
Tom,

There in lies the problem, I don't know VBA.
I have used VBA before, but just in a copy-and-paste mode,
someone gave me code, and I pasted it in.
Is this a rather complicated thing to program?

Thanks


-----Original Message-----
I am curious is this is possible:
It should be possible if you can write/code VBA.

--
Regards,
Tom Ogilvy

"Brian" wrote in
message
...
I am curious is this is possible:

I have a workbook that I use for keeping track of
inventory. Each worksheet is for a different department,
and the inventory for that department is contained in
that
worksheet.

The worksheets are simple. Each contains 4 columns: Part
Number, Description, Quantity, and Location. Each
worksheet's data is sorted descending by part number.

I want to know if I can create a worksheet at the
beginning of this workbook that would allow me to enter
data, hit a button, and have it stored on the correct
worksheet and have the data resorted. I would like to do
this to save time sorting through worksheets and
resorting
data.

Thank you.


.