Hi
there is a small matter and it is: How can I make that Sheet1-A1: A2500 have names, but in B1: B2500 Yes and No I have everything with me Yes it Sheet2 transferred one after another? Example and put to thank everyone in advance to be responded!
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Yes it Sheet2 transferred one after another
3 posts
• Page 1 of 1
Yes it Sheet2 transferred one after another
by k0st4din » Tue Jan 24, 2012 12:23 pm
- 0
You do not have the required permissions to view the files attached to this post.
So ...
1. *Consider well what is your wish.
2. *Make a sample table
3. *Describe in detail what you want to happen is to be understood, not only by yourself.
4. And if you help someone else who needs help.
1. *Consider well what is your wish.
2. *Make a sample table
3. *Describe in detail what you want to happen is to be understood, not only by yourself.
4. And if you help someone else who needs help.
- k0st4din
- Excel Junkie
- Posts: 217
- Joined: Dec 7, 2011
- Location: UK
- Reputation: 3
- Excel Version: 2003, 2007
Re: Yes it Sheet2 transferred one after another
by charles » Tue Jan 24, 2012 2:18 pm
Hi,
See if this is what you want. I used a filter for the "Yes" and had it copy the filtered data to sheet2.
You will need to clear sheet2 each time you click the button. Currently the code will paste to "A2". This can be modified.
See if this is what you want. I used a filter for the "Yes" and had it copy the filtered data to sheet2.
You will need to clear sheet2 each time you click the button. Currently the code will paste to "A2". This can be modified.
- 0
You do not have the required permissions to view the files attached to this post.
There are other ways too do this but...
Be kind let us know if you posted somewhere else!
Charles
Be kind let us know if you posted somewhere else!
Charles
- charles
- Excel Badass
- Posts: 632
- Joined: Dec 10, 2011
- Location: Mississippi
- Reputation: 1
- Excel Version: Excel 2003, 2007 and Mac 2011
Re: Yes it Sheet2 transferred one after another
by k0st4din » Wed Jan 25, 2012 12:24 am
Thank you very much, this will help me in future. I am very happy for rapid response from your side
- 0
So ...
1. *Consider well what is your wish.
2. *Make a sample table
3. *Describe in detail what you want to happen is to be understood, not only by yourself.
4. And if you help someone else who needs help.
1. *Consider well what is your wish.
2. *Make a sample table
3. *Describe in detail what you want to happen is to be understood, not only by yourself.
4. And if you help someone else who needs help.
- k0st4din
- Excel Junkie
- Posts: 217
- Joined: Dec 7, 2011
- Location: UK
- Reputation: 3
- Excel Version: 2003, 2007
3 posts
• Page 1 of 1
Return to Macros and VBA Questions
Who is online
Users browsing this forum: No registered users and 139 guests