On the samples you sent to me you said that you wanted to fill in blanks in
book2 from data in book1. So, the macro works when placed in a module in book2
and executed from book2
Workbooks.Open Filename:="VA_book1.xls"
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Monday, November 07, 2011 9:35 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me
Hi Don Guillett,
Once again thank you very much .
I those two excelbooks saved one folder and named as VA_book1.xls - (one file
-blank file)
and one more file saved as VA_book2.xls .i pasted your coding in VA_book1.xls
and i executed the but its not working
On Mon, Nov 7, 2011 at 8:53 PM, dguillett1 <dguille...@gmail.com> wrote:
Are both files in the same folder? Is the source file named VA_ book1.xls or
book1.xls ?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Monday, November 07, 2011 9:17 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me
Hi
Thank you Very much for your help.
If i run this macros.Some error is showing like VA_book1.xls is not found
error 1004
i have saved correctly in my folder i run the macros but its not working
Please help me
On Sun, Nov 6, 2011 at 8:19 PM, dguillett1 <dguille...@gmail.com> wrote:
Never mind. I determined that you needed to fill in the EMPTY cells using
column D as the criteria, so this macro run from file2 will do it. I also
cleaned up your other modules.
Option Explicit
Sub FillinBlanksSAS()
Dim ds As Workbook
Dim sourcerange As Range
Dim c As Range
Set ds = ActiveWorkbook
Set sourcerange = Columns("D").SpecialCells(xlCellTypeBlanks)
Application.ScreenUpdating = False
Workbooks.Open Filename:="VA_book1.xls"
For Each c In sourcerange
With Workbooks("VA_book1.xls").Sheets("table")
.Cells(c.Row, "d").Copy ds.Sheets("table").Cells(c.Row, "d")
.Cells(c.Row, "g").Copy ds.Sheets("table").Cells(c.Row, "g")
.Cells(c.Row, "i").Copy ds.Sheets("table").Cells(c.Row, "i")
.Cells(c.Row, "k").Copy ds.Sheets("table").Cells(c.Row, "k")
End With
Next c
ActiveWorkbook.Close
Application.ScreenUpdating = True
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Sunday, November 06, 2011 2:00 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help me
Hi Excel Gurus
I have two workbooks(book1 and book2 in a folder)
i need to update some missings data from book1 to book2
which is highligted in yellow color
i dont want to do it vookup -
is this possible thro macros
Thanks in advance
--
FORUM RULES (925+ 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 (925+ 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 (925+ 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 (925+ 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 (925+ 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 (925+ 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
