Hi Ashish
Yes , that's what i had thought, seems a good idea.
Thanks for the help once again..
Thanks and Regards,
Gargee Singh
Date: Thu, 8 Dec 2011 23:18:02 +0530
Subject: Re: $$Excel-Macros$$ $$ excel - macro $$
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
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
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
--
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
