<div>
I am new to excel and i want vba to do this <br />
I need the code to do this Sir
</div>


I am new to excel and i want vba to do this
I need the code to do this Sir

<div>
I understand - I can look at it over the week sometime. &nbsp;But I'll bet there folks on here with specific expertise in running a macro on one workbook and accessing other workflows &nbsp;- if you had a sample pair of workbooks that would be helpful - you can post here with sample data. cheers
</div>


I understand - I can look at it over the week sometime.  But I'll bet there folks on here with specific expertise in running a macro on one workbook and accessing other workflows  - if you had a sample pair of workbooks that would be helpful - you can post here with sample data. cheers

<div>
thnx for the great information &nbsp;Keyboard Cowboy sir
</div>


thnx for the great information  Keyboard Cowboy sir

<div>
<div class="content wysiwyg-content">
There r files that are saved in binary format &nbsp;in the desktop<br />
1)Day(saved in this name in the desktop)<br />
2)Night(saved in this name in the desktop)<br />
what i want is to copy all the data from sheet7 from night file and paste all the data to day file in sheet3 <br />
and save the data in day file and close all the workbooks by vba
</div>
</div>


There r files that are saved in binary format  in the desktop
1)Day(saved in this name in the desktop)
2)Night(saved in this name in the desktop)
what i want is to copy all the data from sheet7 from night file and paste all the data to day file in sheet3 
and save the data in day file and close all the workbooks by vba

conditional copy paste

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.