• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Allocate data from one sheet to the respective fields in another sheet

S

sreejeshc

New Member
Hi

I am having a data in one sheet, which will get updated everyday. In different cells i am having different machine priority list. As and when i update the data in the respective sheet, i need a button called "allocate" which when hit will allocate the respective contents in the appropriate cells in other sheets based on m/c no.

[how can i attach/upload sample file for reference]
 
To upload a workbook, check out the 2nd stickey at top of forums:

http://chandoo.org/forums/topic/posting-a-sample-workbook


W/o seeing any data, just taking a shot in the dark, but perhaps this will help?

http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

or this:

http://www.rondebruin.nl/copy5.htm
 
Hi

I am having a data in one sheet, which will get updated everyday. In different cells i am having different machine priority list. As and when i update the data in the respective sheet, i need a button called "allocate" which when hit will allocate the respective contents in the appropriate cells in other sheets based on m/c no.

Sample file attached


http://www.2shared.com/file/CR7mWAVR/test1_1_file.html


regards

Sreejesh
 
You must log in or register to reply here.
Back
Top