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
code 2 try.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
