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 <vijayajith...@gmail.com>
> *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 <vijayajith...@gmail.com>
>> *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
