Hi, PFA
Thanks Team XLS On Sun, Mar 3, 2013 at 12:52 AM, artforart artforart <artforart...@gmail.com > 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+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. > > > -- ......................... -- 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.
Copy of 1.xls
Description: MS-Excel spreadsheet
