Home » Blogs » Junaid Jan's blog

I want to Input Data in One sheet and move data in another sheet automatically.

Submitted by Junaid Jan on 27 February, 2014 - 12:53

i have to maintain accounts on excel like in the picture 1 there are accounts name like steel, cement, plinth, kesc, blocks i have total 40 accounts and want to enter data in single sheet then its automatically transfer data in others sheet on given criteria like cement entries moves in cement sheet like in picture 2 and steel entries move steel sheet.

i try advance filter but after insert new row in sheet then in another sheet did not update.

Please tell me how i maintain this type of accounts.

PICTURES.jpg
»
Vikas Verma's picture

Try this

Submitted by Vikas Verma on 21 March, 2014 - 07:14.

Please visit: http://excelexperts.com/solution-i-want-input-data-one-sheet-and-move-da...

Hope it will help you.

Warm regards,

»
Almir's picture

Macro with Autofilter for each account should do the work

Submitted by Almir on 4 March, 2014 - 09:37.

I would create a macro to turn autofilter on for each account type, copy visible cells to its sheet, respectively. Is VBA ok?

»