titlerow

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...

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...

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...

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...

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...