Hi Check module 2 *Data_Flex_Merger_Overwrite*
This will meet your requirement..i am not sure of your file structure but i
have tried my best guessing...
Cheers!!
+++++
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 12:15 PM, Zafar Iqbal <ziqba...@gmail.com> wrote:
> Dear Expert,
>
> Now, It is working fine. Bundle of Thanks for it.
>
> I checked my data files and found that exiting files will be revised in
> few cases. In this scenario, only contents of existing file will modify and
> number of rows will remain same, i.e data height which you pointed out
> earlier will not change.
> So, I request that if code finds that file name already exists in sheet,
> then send message "do you want to replace data - File Name?", upon yes,
> replace else go to next file. It will be great help for me, please. Thanks
> in advance.
>
> Regards,
> Zafar Iqba
>
> On Monday, 5 January 2015 17:59:56 UTC+3, Vabz wrote:
>>
>> ok, check this now..
>>
>> Cheers!!
>>
>> +++++
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Mon, Jan 5, 2015 at 8:22 PM, Zafar Iqbal <ziqb...@gmail.com> wrote:
>>
>>> Dear Expert,
>>>
>>> Code is stuck at line For j = LBound(nCount) To UBound(nCount) when run
>>> first time while Active Sheet was blank and data is pasted from target
>>> files.On Second run it is working as per requirement, excluding files whose
>>> Names are already present.
>>>
>>> Paste Special Column Width is not working, right now. Kindly rectify
>>> both problems. Thanks
>>>
>>> Regards,
>>> Zafar Iqbal
>>>
>>> On Monday, 5 January 2015 17:40:42 UTC+3, Vabz wrote:
>>>>
>>>> Hi
>>>>
>>>> Try code in attached excel file...I assumed shipment # will be in third
>>>> row of Product delivery note & there will be only one PD in excel file...
>>>>
>>>> Cheers!!
>>>>
>>>> +++++
>>>> *I did not do this for you. God is here working through me for you.*
>>>>
>>>> On Mon, Jan 5, 2015 at 6:03 PM, Zafar Iqbal <ziqb...@gmail.com> wrote:
>>>>
>>>>> Dear Vabz,
>>>>>
>>>>> For this condition, I request code to exclude/skip those files whose
>>>>> names are already present in sheet. Thanks
>>>>>
>>>>> Regards,
>>>>> Zafar Iqbal
>>>>>
>>>>> On Monday, 5 January 2015 15:19:57 UTC+3, Vabz wrote:
>>>>>>
>>>>>> hi
>>>>>>
>>>>>> Height of every file is not same, so how you want to paste data on
>>>>>> existing data if file no. is matching?
>>>>>>
>>>>>> +++++
>>>>>> *I did not do this for you. God is here working through me for you.*
>>>>>>
>>>>>> On Mon, Jan 5, 2015 at 5:03 PM, Zafar Iqbal <ziqb...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Dear Experts,
>>>>>>>
>>>>>>> By hit & trial method, I got file name with file path by adding line
>>>>>>> Range("A65536").End(xlUp).Offset(3, 17) = FileName in the code.
>>>>>>> Please guide me how to get file name only from full path address. I
>>>>>>> will need answer to balance points # 2, 3 & 4 from you, please.
>>>>>>>
>>>>>>> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Consolidate Data.xls
Description: MS-Excel spreadsheet
