Auto insert data to seperate sheets?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

greig2000_uk - 26 May 2006 18:56 GMT

Hi,
I have a Excel (2003) workbook consisting on 4 sheets, sheet 1 has 9
columns, sheet 2 has 4 columns, sheet 3 has 2 columns.
Sheet 4 is used for new data which will usually stay on this sheet for a few
weeks before I manually copy it over to the relevant sheet then manually
arrange it. The whole workbook is arranged alphabetically.
I would like to be able to insert new data in sheet 4 but at the same time
the entered data inserting into another sheet of my choice and in its
relative alphabetical row, Is this possible?

any help much appreciated

many thnx

Reply to this Message

bgeier - 26 May 2006 23:08 GMT

It is possible, but can be rather complex.
To do it, you would put your data into sheet 4, then set the criteria
to paste to which ever sheet you want.
Once the criteria have been set, select the cells you want pasted to
the respective sheets, then search for the insertion point and insert.

It would have to be done in VBA because of the volitility of the data

Signature

bgeier

Reply to this Message

greig2000_uk - 27 May 2006 13:10 GMT

OK m8, many thnx for that :)

g2k.

> It is possible, but can be rather complex.
> To do it, you would put your data into sheet 4, then set the criteria
[quoted text clipped - 3 lines]
>
> It would have to be done in VBA because of the volitility of the data

Reply to this Message