View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bruno Campanini[_2_] Bruno Campanini[_2_] is offline
external usenet poster
 
Posts: 74
Default Macro Required - 13th April 2017.

Akash Maheshwari used his keyboard to write :
Hi,

Require Help!!

I have three workbooks:

ABC.xls
DEF.xls
Summary.xls

ABC is updated by one employee.
DEF is updated by second employee.

I want an update button in the workbook named as Summary. As soon as I click
on update button, the system should pick data from respective cells of the
two sheets and update in Summary Sheet.

How can be defined "respective cells"?
Are they a one-column range dynamically definable or an x-columns
wide range?

Bruno