Posts

How to create/record macro to save the sheet in a separate excel & perform some action on the sheet

Image
In the last article , we learnt what macro is and how to create it for performing repetitive tasks on the same work book, just on a single click of button. In this article, we will be learning about how to create macro to take data from current workbook sheet, perform manipulation in new book and save it at desired location just on the click of keyboard short cut. During the manipulation we will create a pivot table. This is the basic example with limitation that once macro is run. You would need to close and reopen macro enable excel before running it again. In upcoming articles, we will talk about removing this limitation. The sample macro enabled excel can be accessed from here . On running the macro on the click of 'Ctrl + y ', It generates the excel at 'C:\temp\excel\NewWorkbook' location. Please ensure that this location exists in your computer before running the macro. If you wish to create the macro using coding rather than recording. Sample c...
Post a Comment
Read more

How to create/record and run macro for finding duplicates in excel

Image
Macro represents a set of instructions which can be executed in a single command/trigger to perform specified actions. These are used to automate the repetitive tasks with in Microsoft office products like excel etc. Microsoft word and excel provide a mechanism to record the steps performed and then link it to some triggering mechanism like button etc so that all of the recorded steps could be executed again just on a single trigger like click of button. Today we will do the step by step demonstration of recording the macro to be used for finding the duplicate & corresponding number of occurrences and running the macro just on a single click. The sample excel initially had only one column having names and at the end of the exercise we had created a macro and a button for trigger. On the click of button, macro populates the duplicate names and corresponding count in second sheet. The sample excel with macro created as a part of this exercise can be accessed from here . In ...
Post a Comment
Read more