Hi,
I would like to take the contents of a column and split it into multiple worksheets.
example Column b has values of Pa,GT,CR
I would like to automatically create 3 tabs(worksheets) PA,GT,CR.
thanks in advance!
Hi,
I would like to take the contents of a column and split it into multiple worksheets.
example Column b has values of Pa,GT,CR
I would like to automatically create 3 tabs(worksheets) PA,GT,CR.
thanks in advance!
Hi,
One way assuming your names are in a contiguous list in Sheet1 column A with nothing in column B. i.e. the .CurrentRegion will accurately count the list of cells in column A
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
I have data in most of the columns. Data is within A,b,c,d,e,f,g ,but I want to sort and create a worksheet by using the contents of Column B.
Would the solution you provide do that?
Yes,
Just modify to
For x = 1 To Sheet1.Range("Bf:Bl").Cells.Count
Sheets.Add.Name = Sheet1.Range("Bf").Cells(x,1)
Next x
where f and l are the first and last row numbers in column B which contain your sheet names.
ok It sounds good now what do I do with the info you provided me?
Try this code
Copy the Excel VBA codePlease Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Sorry Still trying to get my bearings with this. I'm getting an error"Run-time error '9': Subscript out of range"
I get that error for Arlu1201's code
Richard. For your first code I got the same error above,but for your edit code
I get Run-time error '1004':
Method 'Range' of Object'_Worksheet'failed
Last edited by jjexcels; 10-10-2013 at 01:01 PM.
What is the name of the sheet containing the data?
Are there any blank cells in column B?
Hi,
Copy and paste the actual code you are using so we can check.
And can you confirm that you are using the VBA sheet CODE name. My example used 'Sheet1' but of course yours may be different. And don't confuse the VBA sheet CODE name with the Excel sheet TAB name. The two may be the same but they may also be different.
OK.not sure what I was doing wrong,but this time is works!!
How do I get a summary of all the data based on a column from the master sheet or
by the worksheet tabs?
Can you tell me which cell's info you need in the summary?
So on a separate worksheet , The data would be summarized.
For example column N contains different countries. The summary should have a count for all records that contain the same country.
Sort by Column "N" Country field
Then drill down using
Column "L"contains "Y" or "N"
Attaching a picture of my current outcome when manually entering the data.
Attachment 270986
Your attachment didnt load properly. Can you please try again?
How big is your file? There is a max limit of 1mb for excel files.
Im under the max. Were you able to get the doc2.docx file I uploaded? That file contains the screen shot I initially tried uploading
I am not talking about a screenshot. You need to upload an excel file so we can work on it and give you a working solution.
Attachment "Week2" has the raw data I use to create attachment "progress" Is there a way to run a macro that will create "progress"?
Hi guys just curious if you had any luck? I have uploaded the file. Thanks
This is your first post.But that doesnt match with the progress sheet you uploaded.I would like to take the contents of a column and split it into multiple worksheets.
example Column b has values of Pa,GT,CR
I would like to automatically create 3 tabs(worksheets) PA,GT,CR.
Ok . Ill open a new post
What about this thread?
My intent was to eliminate some of the manual work it takes to compile progress. After receiving some excellent advice I was hoping to \automate other steps I manually do.
IF this could be covered in one post it would be great, but if I need to open a new one please let me know.
Ok, do you have anything pending to be solved as per your 1st post of this thread? If there is, we can work on it and then any additional stuff you want to be done, can be done in another thread.
Nothing is pending from my first thread. You can close this issue as solved. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks