Required help for writing a excel macro

Closed
ALAM - Jun 16, 2010 at 08:22 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 08:28 PM
Hi all,

I am new in excel macro programming. I need a macro for update the
pending works lists as describes below.

#######

Master Sheet(Worksheet name: Master): contains the all pending works.

Different project works in separated sheets ( on same excel file):

Project Name: AAA Sheet name: AAA
BBB Sheet name: BBB
CCC Sheet name: CCC
DDD Sheet name: DDD
...
...
Total: 15 sheets.
Each sheets contains a column "N" with string data: "Finish" or "Pending"


I place a button in master sheet, name : "Update pending works".

I wish by clicking update button, all 15 work sheets pending works will
be uploaded in the master sheet ( Full row as each separated 15 sheets
have).

Could any one please write a macro function for update button??

#######

Thanks in advanced.

--ALAM

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 16, 2010 at 08:28 PM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0