sheet creation

Hello everyone! I have made a sort of registry crm where one enters product code and quantity, excel returns name of product and price*quantity, plus it calculates start and end registry, loses, gains and other stuff. Some macros that clear specific cells and 2 more macros that: 1. user enters a...

Hi I have statistical data on text file and import to excel with import text wizard and split to column. I have multiple criteria on this file and want to spli to multiple sheet per criteria. this is one example file: Number of Observations Read 102...

I asked this a few weeks back and did not get any hints. Trying again I have a worksheet with header block currently sized a1:eJ and rows with data (Header is likely to widen over time). I have two separate types of worksheets I'd like to create with this: First, individual sheets for each...

Hi there, I need a macro which can able to create an excel with 3 sheets based on the following criteria. <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Name Age Gender Salary Ram 25 M 10000 Ganesh 23 M 2000 Saleem 10 M...

Hi Forum, It's a pleasure joining your forum and I hope that you can answer my question or atleast give some input. I need to make a lot of sheets with different name but the same functions and formating. Let me try to split the problem up in more two parts. 1) Create sheets with name of...

I’m looking vba code in order to segregate the data as per below requirement. I have sheet1 which contains the data and required to copy this data till 90 line items including empty rows and needs to paste special in new sheet. This new sheet name should be changed to Setitem1 and it should...

Hello, I have a macro that will create sheets from a 'master' sheet based on the description that it has in Column "A". The problem is that I haven't been able to make the macro name the new sheets based on the description that comes from Column "A" in the 'master". My macro will create...

Hi I have a sheet and have data in the cell from A2 to A 17 i want a macro that will copy the data from cell and create a sheet in the workbook. prashanth