Try this
Sub UpdateMasterFileSAS()
Set ss = Sheets("source sheet")
Set ds = Sheets("destination sheet")
dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row
sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1)
ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1)
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: gargee singh
Sent: Thursday, December 08, 2011 11:00 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ $$ excel - macro $$
Hi Ashish,
Thanks for your reply.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 again for the help.
Thanks and Regards,
Gargee Singh
--------------------------------------------------------------------------------
Date: Thu, 8 Dec 2011 22:16:52 +0530
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
can you attach the sample file and send it to the group id
excel-macros@googlegroups.com
On Thu, Dec 8, 2011 at 9:54 PM, gargee singh <garge...@hotmail.com> wrote:
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
--
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
