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
> ---
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
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
>
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
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
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
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
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
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
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
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
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
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:
>
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
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
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
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
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
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
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.
Sub Data_Flex_M
20 matches
Mail list logo
