Copying data from multiple work sheets to a master sheet

I am trying to create a stock register and i want to copy data from a particular cell of each sheet to a master sheet as shown in attachment.i searched and found some code suitable and works good if the particular cell contains only a number or any text. but if the data in the particular cell is the result of some arithmetic formula, then the copy result is zero. i am new to vba.

for example in the attached file, in sheet 2 , if the cell B2 is the result of C2-D2, the result in Master sheet (ie C2) is 0. if it is not a result of any formula (simple number/Text), then it will get correctly displayed in Master sheet..

Kindly suggest a solution pls.
Thanks in advance.

Please Login or Register  to view this content.

Thanks a lot sir.. it helped me to complete my project.. a million thanks...

thanks. i know how to take data from a sheet of same work book but not know how to take data from another workbook..actually i am new to exel programming..anyway thank you sir..

Hi, the code you have provided will also work for what I need to do, but I've only ever done this once and can't remember the steps to insert this into excel. It would be great if you could advise!

Thanks in advance.

Hi, the code you have provided will also work for what I need to do, but I've only ever done this once and can't remember the steps to insert this into excel. It would be great if you could advise!

Thanks in advance.

Carrrie,
We would help, but you need to post it a new thread. It is against the rule of this forum to post on someone's thread.
So, please start your own thread and if possible attach a sample book with a desired result.