Hello there!
I've been trying to find a code that creates a new sheet at each change in data in a special column, but I can't seem to find any that works for my sheet.
Sheets:
(1)Colors(2)Blue(3)Green(4)Red
A Blue A Blue A Green A Red
B Blue B Blue B Green B Red
C Blue C Blue C Green C Red
D Green
E Green
F Green
G Red
H Red
I Red
I want it to be like this. The new sheets should be named after the data in the column as well. Hope this is possible to fix.
Thank you in advance!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Dont understand your want.
scan down a column and everytime the color changes in col1, paste them to a new sheet?
Sorry for late answer!
This is how I want it:
Sheet1 (this is the starting point)
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6
Sheet7
Sheet8
Sheet9
Is there any genius out there who knows how to handle this problem? Help is very much appreciated!
EDIT: Here is a piece of my file
Last edited by gliori; 06-17-2015 at 05:02 PM.
Please find the attached workbook and click on the Green Button to run the code on Module1 to get the desired output on the relevant sheets.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Wooow! Nice thank you a lot!
However it seems to be one small issue.. On some sheets it doesn't show the sum on the bottom row, only "#####". But the formula is still there and when I select the cell and press enter it shows the sum, not "#####"... Really strange
Is this possible to fix?
Best regards!
#### is there because the column width is not enough to show the cell content.
Fixed that, so see if it is working as per your expectations.
Hi gliori,
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Great! That's exactly what I wanted, perfect! A very, very BIG thank you to you! Very much appreciatedOriginally Posted by sktneer
Alright, I'll do that!
You're welcome. Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks