vcol

Hello, I was able to find VBA code that splits data from one sheet into new sheets based on a criteria in a certain column, but I need to figure out how to select what columns I want to go on the new sheets. For example, I want to split my data based on the column H (Tab) because I have already...

Hi There, Happy new year to all! I'm trying to solve a problem that I have from a VAB code that I have found on the Internet. its about splitting one sheet into multiple sheets. Code runs fine but every time it gives me a extra sheet that I don't want like ("sheet69"). Is this problem ready...

I've used a Macro that's designed to separate data from a master worksheet to relevant sub worksheets based on the value of column 2. (vcol = 2) The initial record works - it appears in the correct worksheet. However when I attempt to enter a record with a different vcol value it won't appear in...

Here is the macro I am using.. why am I getting sheets that show up with nothing instead of it just skipping to the next group. Private Sub CommandButton1_Click() 'Sub parse_data() Dim lr As Long Dim ws As Worksheet Dim vcol, i As Integer Dim icol As Long Dim myarr As Variant Dim title As...

Hey Guys, I need help to doing following in VBA. In my Main worksheet, i will be having a template, that needs to be copied into 70 new tabs. Basically 70 Identical Sheets. However the differentiation between them is that, In Row 1 (A1,B1) each tab needs to show Unique Store + ID. Basically if...

Hi, I'm fairly new to VBA and I made up some code here that makes me transfer data from one workbook to another. I have two workbook variables names wbk1 and wbk2. The problem is, the code works only once. Afterwards, I have to close the second workbook file (wbk2) in order for it to work...

I have a sheet that I am using "parse data" macro to break into separate workbooks, then another macro to save each workbook to its own file. I receive the Removed Feature message and the data validation is gone. How can I keep all the data validation in place and to follow the macros and...

Hiya I am struggeling to create a macro that wil simplefy my report making a little. I have a set of items I need to report serial numbers on each month and the items are not always the same. I have created myseld a Data sheet where I will input the data (se sample) some days there can be 20...

Hi - I'm using this code to parse data from another sheet and it's working perfectly. However, I want to also add a total of each column from H to AM on each newly created worksheet. Is this possible? My issue with other codes I've found is that you have to specify the names of worksheets or...

I have this code that I'm certain I took from this board last year and have used successfully many times to split data to worksheets by unique values in a column. I'm trying to use it now and it's working, but with errors. Some of my "unique" data has more than 31 characters and the code is...

I currently use the below code to split data by provider last name, from a list of quality metrics that are due. This is a multistep process to trim the csv file I receive with 60 columns of data and a variable number of rows, down to the 9 columns of data that I have sorted by what is...

My code below is functioning just as I'd hoped...almost! I'd like the files to be created in new workbooks rather than sheets. Can someone assist me with the necessary edit to accomplish said result? Thanks Sub parse_data()Dim lr As Long Dim ws As Worksheet Dim vcol, i As Integer Dim icol As...

I am in need of help of furthering the vba code that I have below. Right now I have it breaking down the particular names in a column into different worksheets. What I would like to further do is to do a count of each different name in a column but also check in a different column if a...

Hi all, I have a really disgusting piece of VBA code and I apologise now to those that look at the code in disgust. I am trying to get the code to loop through all files in the folder and perform the VBA code and it opens the file and then fails to perform anything. Please can you help in...