Name: How to copy Excel data from one sheet to another and print the extracted report
Uploaded: 2012-07-21T06:13:16+00:00
Duration: 12 min 15 s

How to copy Excel data from one sheet to another and print the extracted report

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
http://www.familycomputerclub.comYou can copy data from one Excel worksheet to another based on criteria to create a report automatically and then print it with a single click. The code for copying the data using a do while loop macro is described in greater detail than before because many people didn't find this easy to understand or had problems implementing it. Also an idea on how to correct errors in a macro is given. Please remember the macro code must be 100% correct to give the intended results.
The print macro is also attached to a command button like the copy macro and is only one line of code!
http://www.youtube.com/watch?v=KU8mUv...
If you have any problems with viewing the complete code then just go here:
http://www.familycomputerclub.com/cop...

Video Length: 12:15
Uploaded By: Dinesh Kumar Takyar
Published: 7/21/2012
View Count: 44,012

Related Software Products

Advanced Excel Report

Published By:
EMS Software Development

Description:
Advanced Excel Report component for Delphi and C++ Builder is a powerful band-oriented generator of template-based reports in MS Excel. Easy-to-use component property editors allow you to create powerful reports in MS Excel quickly, easily and intuitively understandable. Now you can easily create reports, which can be edited, saved to file and viewed almost on any computer. Advanced Excel Report supports Borland Delphi 5-7, 2005, 2006 and MS Office 97 SR-1, 2000, 2002 (XP), 2003. Key Features: ...