can you add some content to e11: e 490 and show us how would u like to be pasted on the mtd sheet
On Fri, Dec 9, 2011 at 9:52 PM, gargee singh <garge...@hotmail.com> wrote: > Hi all > > > I need yet another help. In the above attached workbook i need to copy > data from audit sheet and paste it into the mtd consolidated sheet and this > has to be done for multiple sheets. > > I had worked out the code and it is saved in the workbook (shortcut is > Ctrl +Q) and it works fine except that it copies D1:D49 and due to some > requirements I also need to add the range e11:e47 to the code and i would > take a lot of time to do that as i am a beginner in vb. > > ** This is what i need - > copy row d1:d49 along with the cell which has feedback and copy e11:e47 > into the next sheet. > > Please help as this is urgently required and i am unable to do this. > > Everyone's time and help is sincerely appreciated on this. > > > Thanks and Regards, > Gargee Singh > > > -- > FORUM RULES (934+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com