Required help for writing a excel macro [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!