Hi Ashish
I had just one more question and i just thought about it that is for the first
of every month the destination workbook would be blank as no data would have
been consolidated and this code doesn't work.Please help.
Once again thanks for all the help.
Thanks and Regards,
Gargee Singh
From: garge...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ $$ excel - macro $$
Date: Thu, 8 Dec 2011 22:58:21 +0530
Hi Ashish,
Thanks for such quick reply and time.
This is fantastic :) .Completely meets my requirements.
Thanks and Regards,
Gargee Singh
Date: Thu, 8 Dec 2011 22:51:54 +0530
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
open destination file run the macro and choose the source file
On Thu, Dec 8, 2011 at 10:44 PM, gargee singh <garge...@hotmail.com> wrote:
Hi Don,
Thanks for the reply and i dont have a code ready , i tried a lot but nohing
seemed to work and please find the attached sheet.
Please find the attached sheet.The source sheet is what the source data will
look like and the destination sheet is where i want the consolidated data.
Source sheet has data till 8-dec -11 and destination sheet has data only till
5-dec-11 so i want the code to copy data for 7 dec - 8 dec and so on (ie pick
last date for which the data was updated and update data for all dates after
that.
One thing i would like to inform is that the destination data and source data
will always be in ascending order. ie dates from 1-2-3 dec and so on.
Thanks and Regards,
Gargee Singh
From: dguille...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$
Date: Thu, 8 Dec 2011 11:09:11 -0600
It would be helpful to post your code and/or file (if allowed)
Don
Guillett
SalesAid Software
dguille...@gmail.com
From: gargee singh
Sent: Thursday, December 08, 2011 10:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ $$ excel - macro $$
Hi experts
I urgently need help with
a code.
Though I have tried a lot
of options just couldn't get the accurate code.
This is what i need to do
--
* copy data from one
workbook and paste in another workbook at the next blank row (since there will
be some data in the destination sheet which i cannot delete)
* the condition to copy
data is that the code should copy data from the next applicable date for which
there is no data in the destination sheet :
eg: if the destination
sheet has data only till 6 dec then the code should copy data for 7 &
8 December and exclude all the data for 6th december
Please help me as this is
urgent and if i have not followed the correct path to post a query please let
me
know so that I can follow the correct route.
Everyone's time on this is
sincerely appreciated.
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
--
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
--
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
