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.
1.xls
Description: MS-Excel spreadsheet
