Hi Ashish,
If you select both the columns ie D and E in audit sheet and do a paste special
- transpose , that is what it should look like .
Thanks and Regards,
Gargee Singh
Date: Fri, 9 Dec 2011 22:21:01 +0530
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
whr do u want to paste the remark section
On Fri, Dec 9, 2011 at 10:18 PM, gargee singh <garge...@hotmail.com> wrote:
Hi Ashish,
Done as required . I am sorry it would be e11:e47.
It would be a very short note kind of thing.
Thanks and Regards,
Gargee Singh
Date: Fri, 9 Dec 2011 22:14:05 +0530
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
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
--
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
--
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
