Dear Expert.
Excellent Work. Bundle of thanks for it.
Regards,
Zafar Iqbal
On Saturday, 10 January 2015 10:51:39 UTC+3, Vabz wrote:
>
> Hi Zafar,
>
> check this attachment..
>
> Macro will chk for sheet name exist for filename for file string
> -001.xls
>
> If exist then data will b
Dear Expert, No need of replacement of existing data if it will be
difficult to handle in big code. Thanks
On Jan 8, 2015 6:46 PM, "Vaibhav Joshi" wrote:
> And what abt same records if exist.. wanna replace or keep duplicate
> records??
> On Jan 8, 2015 9:15 PM, "Zafar Iqbal" wrote:
>
>> First
Dear expert, Summary sheets for other files like 710, 720, 725, 525, 3490,
etc will be created when later on code will run and it will find such
files. Thanks for your quick help.
On Jan 8, 2015 5:41 PM, "Vaibhav Joshi" wrote:
> what if there is sheet with name 2400, 2401 & 600 already exist?
>
And what abt same records if exist.. wanna replace or keep duplicate
records??
On Jan 8, 2015 9:15 PM, "Zafar Iqbal" wrote:
> First run of code will create summary sheets 2400, 2401, 600, etc. Later
> on while updation new files data will be pasted below existing data in
> related summary sheets
First run of code will create summary sheets 2400, 2401, 600, etc. Later on
while updation new files data will be pasted below existing data in related
summary sheets. Like 2400-08.xls will be pasted below existing last data in
summary sheet 2400.
On Jan 8, 2015 5:41 PM, "Vaibhav Joshi" wrote:
>
what if there is sheet with name 2400, 2401 & 600 already exist?
What about rest of file name?
ᐧ
+
*I did not do this for you. God is here working through me for you.*
On Thu, Jan 8, 2015 at 2:38 PM, Zafar Iqbal wrote:
> Dear Experts,
>
> We are getting quick help from you. We appreciate y
Dear Experts,
We are getting quick help from you. We appreciate your efforts, always.
Attached Code copies a Range from Sheet1 from Selected files & Paste in
Active Sheet below each other. Kindly help in making this code more
flexible as per below requirement.
There are +400 excel files named
