View Single Post
 
Old 07-25-2015, 04:06 AM
Cheezee Cheezee is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jul 2015
Posts: 1
Cheezee is on a distinguished road
Default Challenging VBA Code

Hi guys, First of all I would like to thank you for visiting my thread and hoping that you could help me to solve this VBA Code

Pls see attachment for Excel file.

As you can see in the attachment there is 3 files of excel namely Previous, Present and DesireOutput

Here's what we going to do we need to build/create a VBA code that can extract the difference of cell value in every sheet of workbook namely Previous and Present. The extracted value of the difference will create a new workbook which is DesireOutput.

In the attachment file it has 3 sheet, but this sheet varied depending on project load.
Attached Files
File Type: xlsm PresentW Workbook.xlsm (326.4 KB, 12 views)
File Type: xlsm Previous Workbook.xlsm (326.7 KB, 12 views)
File Type: xlsx DesireOutput.xlsx (324.7 KB, 14 views)
Reply With Quote