Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
Cheers!! On Jan 6, 2015 9:10 PM, "Zafar Iqbal" wrote: > Dear Expert, Great Job done by you. > > You did an excellent work. So nice of you & surely I expect more help fro > you for next challenges. Thanks > > Regards, > Zafar Iqbal > ---

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
Dear Expert, Great Job done by you. You did an excellent work. So nice of you & surely I expect more help fro you for next challenges. Thanks Regards, Zafar Iqbal --- On Tue, Jan 6, 2015 at 6:35 PM, Vaibhav Joshi wrote: > Also check o

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
Also check over write module On Jan 6, 2015 9:00 PM, "Zafar Iqbal" wrote: > Dear Expert, Thanks for it. I will shift overwritten data manually from > end to its proper location. You did great work for us. Bundle of thanks. > > Regards, > ZAFAR IQBAL >

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
Dear Expert, Thanks for it. I will shift overwritten data manually from end to its proper location. You did great work for us. Bundle of thanks. Regards, ZAFAR IQBAL --- On Tue, Jan 6, 2015 at 6:15 PM, Vaibhav Joshi wrote: > Check this

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
Typing mistake. Sort 600-01, 600-02, 600-03 and so. --- On Tue, Jan 6, 2015 at 6:08 PM, Zafar Iqbal wrote: > Dear Expert, Thanks for it. Can we sort data later on in code and position > them in proper ascending 6001-01, 600-02 & so

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
Dear Expert, Thanks for it. Can we sort data later on in code and position them in proper ascending 6001-01, 600-02 & so on? Regards, ZAFAR IQBAL --- On Tue, Jan 6, 2015 at 5:59 PM, Vaibhav Joshi wrote: > Try code from module ..Data_Fl

رد: Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread naef77
Hi Can someone help me regarding charts in excel Thanks تم إرساله من الهاتف المحمول Samsung. الرسالة الأصلية من: Vaibhav Joshi التاريخ:٢٠١٥/٠١/٠٦ ١٧:٤٧ (GMT+03:00) إلى: excel-macros@googlegroups.com نسخة: الموضوع: Re: $$Excel-Macros$$ Re: Data Consolidate with

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
Try code from module ..Data_Flex_Merger_AddToEnd This wll delete existing data & add that file at the end.. + *I did not do this for you. God is here working through me for you.* On Tue, Jan 6, 2015 at 8:17 PM, Vaibhav Joshi wrote: > can you send me three separate files.. > > + > *I di

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
can you send me three separate files.. + *I did not do this for you. God is here working through me for you.* On Tue, Jan 6, 2015 at 8:11 PM, Zafar Iqbal wrote: > Dear Expert, I appreciate your guidance. There is minor correction still > needed. Now, it is deleting some data down the bottom

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
Dear Expert, I appreciate your guidance. There is minor correction still needed. Now, it is deleting some data down the bottom. Data of Files 601-01, 600-02, 600-03, 600-04 & 600-05 Exists in sheet. Overwrite of first file 600-01 (only), Delete Contents of 600-02 and 600-03 (two files) whereas

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
Check this In your original code you was selecting whole range from data file... I rectified to select upto last used row... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Jan 6, 2015 at 7:29 PM, Zafar Iqbal wrote: > Dear Expert, It is very ni

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
Dear Expert, It is very nice. Thanks for it. A little problem is observed. If data over write is falling at start or in middle of existing data, it overwrite well, but delete exiting data down the bottom. For example, Data from files 601-01, 600-02 & 600-03 already exists. When overwrite of 60

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
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 wrote: >

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-05 Thread Zafar Iqbal
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-05 Thread Vaibhav Joshi
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 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 d

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-05 Thread Zafar Iqbal
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 w

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-05 Thread Vaibhav Joshi
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 wrote: > Dear Va

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-05 Thread Zafar Iqbal
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-05 Thread Vaibhav Joshi
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 wrote: > Dear Experts, > > By hit & trial method, I got file name