in that case u can type the staring date of month manually in cell a2 in
destination file before you run the macro
rember date fromat should be same
On Thu, Dec 8, 2011 at 11:11 PM, gargee singh <garge...@hotmail.com> wrote:
> Hi Don
>
> Thanks for your time and help , one fellow group member helped me with
> the code and it seemed to work fine.
>
>
>
>
> 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:24:55 -0600
>
>
> 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 <garge...@hotmail.com>
> *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
>
> --
> 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
