Macro to trasnfer data between worksheets








Asset

data1 data2 data 3 status   
ABC ddd ddd ddd  
CDE ddd ddd ddd  
FGH ddd ddd ddd  
IJK ddd ddd ddd  

WS 1 Above

WS 2 below










ABC  
task status
t1 comp
t2 comp
t3 comp
t4 comp
  completed




if A1 of worksheet 2   = a cell in column A of Workbook 1
Then populate WS1 corresponding cell in column E (E2 in this case) with data from B7 (WS2)… macro button needed to perform this function in excel 2013

 

By: Paul Kempinger

Leave a Reply

Your email address will not be published. Required fields are marked *