$$Excel-Macros$$ Re: Arrangement head of the table in the macro code

[artforart artforart]

If I add this bold part in code I've got End if without block if 

For Each Wks In ThisWorkbook.Worksheets
If IsNumeric(Wks.Name) Then *Wks.Name = "Year " & Wks.Name*

If Wks.Name >= 2010 And Wks.Name <= Year(Date) Then

Thank u for help

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Extract Data from single cell

[artforart artforart]

W dniu piątek, 1 marca 2013 12:48:12 UTC+1 użytkownik amar takale napisał:

I don't know what is your question. If u want to extract using:
 

> *Date -> text as column -> constant width a*nd and U adding require split 
> columns for date 
>

For date with *dash* using as separator for split column.

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ How to do an automation for copy paste, added new row? (macro)

[artforart artforart]

Hi thank u for help offset is good for names. But what about date.?

I've got some macro code. But there is some problems
1) with loop macro:
I use macro only for sheet: table Z. When I start macro then added me next 
year below from source date. For example when I want to got 2012 I added a 
source date - new sheet 2012 (in attachment is ready added) and I start 
macro table Z etc. every years. When I want put 2014, it is something wrong 
(loop doesn't work)

Could u look on this cod of macro aaa? (I've attached file)
Till 2013 is ok. How to do a loop for more years 2014, 2015 etc.? What 
should I added in code?

2) After used macro the formula bar (table Z) is lost. Formula bar shows a 
source date. Is it possible that the formula showed after used macro?

Regards. Thank you so much in advance for your answer, ideas.

W dniu niedziela, 3 marca 2013 09:46:23 UTC+1 użytkownik XLS S napisał:
>
> Hi,
>
> PFA 
>
> Thanks
> Team XLS
>
> On Sun, Mar 3, 2013 at 12:52 AM, artforart artforart 
> 
> > wrote:
>
>> Hello
>> I have attached file
>>  <http://www.sendspace.com/file/wjh0oe>
>> I want to automated a some step (tab table Z)
>>
>> Thus, for example, that in X 2012:
>>
>> 1) I want to copy D16:E16 
>> 2) added a new one blank below before the paste D17:E17
>> 3) converted the 2011 to 2012 in cells D17: E17 (ctr+h function find 2011 
>> replace the 2012)
>>
>> and by analogy, 1) 2) 3) for Y
>> And just every year
>>
>>
>>
>> In the point 3) conversion step, it can converts the 2011 to 2012 or 2010 
>> to 2012 as comfortably.
>>
>>
>> PS: I've got some macro cod. But there is some problems 
>> 1) with loop macro:
>> I use macro only for sheet: table Z. When I start macro then added me 
>> next year below from source date. For example when I want to got 2012 I 
>> added a source date - new sheet 2012 (in attachment is ready added) and I 
>> start macro etc. every years. When I want put 2014, It is something wrong 
>> (loop don't working)
>> 2) After used macro the formula bar (table Z) is lost.( formula bar show 
>> a source date)
>>
>>
>> U have any cod, idea ? write boldly. If someone wants to test this cod. 
>> I can send it also.
>> Regards. Thank you in advance for your answer
>>  
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
>
> -- 
> .
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




1 macro.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ How to do an automation for copy paste, added new row? (macro)

[artforart artforart]

Hello
I have attached file
 
I want to automated a some step (tab table Z)

Thus, for example, that in X 2012:

1) I want to copy D16:E16 
2) added a new one blank below before the paste D17:E17
3) converted the 2011 to 2012 in cells D17: E17 (ctr+h function find 2011 
replace the 2012)

and by analogy, 1) 2) 3) for Y
And just every year



In the point 3) conversion step, it can converts the 2011 to 2012 or 2010 
to 2012 as comfortably.


PS: I've got some macro cod. But there is some problems 
1) with loop macro:
I use macro only for sheet: table Z. When I start macro then added me next 
year below from source date. For example when I want to got 2012 I added a 
source date - new sheet 2012 (in attachment is ready added) and I start 
macro etc. every years. When I want put 2014, It is something wrong (loop 
don't working)
2) After used macro the formula bar (table Z) is lost.( formula bar show a 
source date)


U have any cod, idea ? write boldly. If someone wants to test this cod. I 
can send it also.
Regards. Thank you in advance for your answer
 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




1.xls
Description: MS-Excel spreadsheet