Dear Genius,
I agree with you that legend can be placed as a free item on any side of
table. However, my question is about Legend which is permanently attached
to Data Table in Chart. It remained stitched to chart data table and does
not need to be adjusted manually while we increase / decrease
to shift Data Table Legend on Right Hand Side of Chart.
Sample file is attached. Thanks for your support, in advance.
Regards,
Zafar Iqbal
--
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
Check if it helps ...
[image: Inline image 1]
Regards,
ZAFAR IQBAL
+966 (14) - 325 1654, 325 3484, 325 4148 - Ext - 2011
On Sat, Jul 15, 2017 at 5:31 PM, Srinivas G wrote:
> Hi Friends,
>
> I want to help in Excel
>
> ramu Ramu False
> Raju Raju
Copy 1st row, paste special transpose at new location, copy 2nd row and
paste special transpose, move on same way till last row.
Zafar Iqbal
--
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
provide
some Formula which will attach Text to Numbers automatically while result
remains as Number. Sample file is attached. Thanks a your guidance in
advance.
Regards,
Zafar Iqbal
--
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
Dear Expert, Contents in Cell F2 on Sheet is being ignored by search
formula. F2 is first cell of database range "Column F". Your VB Search is
working well for contents in other cells from F3 downwards.
On Tuesday, 5 May 2015 14:51:37 UTC+3, Mandeep Baluja wrote:
>
> what F2 i didn;t get you ???
Dear Expert. You did a great job. I noticed that it is ignoring value in F2
(only). I think F2 is excluded from VB Range by mistake. Sorry for late
response, as our Net was not operative for last 2-3 days.
Regards,
Zafar Iqbal
On Sunday, 3 May 2015 21:38:55 UTC+3, Mandeep Baluja wrote
14”, 24”,
etc.
When I want to Search 1/4”, current formula brings text items
containing 1/4” and non-related items like 1 1/4", 2 1/4", etc.
Kindly help to exclude texts with non-related fractions and attached
integers on left side. Thanks
Regards,
ZAFAR IQBAL
--
Are you =EXP(E:RT) or =NOT(E
Dear Experts,
Kindly help in formula to count unique values in give date range. I tried
with sumproduct but failed. Sample data is attached. Thanks for your kind
support, always.
Regards,
Zafar Iqbal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT
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
>
&
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 I
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.
ot; 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
iles.
Your guidance & quick support always make our life comfortable. Thanks in
advance for your help, please.
Regards,
Zafar Iqbal
--
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.face
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:
> Als
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:
> Ch
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,
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
0-04 is carried out there is no error to below data
(un-touch). Please help for this error. Thanks
Regards,
Zafar Iqbal
On Tuesday, 6 January 2015 17:17:58 UTC+3, Vabz wrote:
>
> Check this
>
> In your original code you was selecting whole range from data file...
>
> I rectifi
e of 601-01 (first file) is needed, it will delete all data below
from files 600-02 and 600-03. Similarly if over write is for 600-02 only
(middle file) then date below it 600-03 is deleted. Can it be rectified,
please? Thanks for your efforts & excellent work, always.
Regards,
Zafar Iqbal
On
ry 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 > wrote:
>
>> Dear Expert,
>>
>> Code is st
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 o
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
>
ste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
Application.CutCopyMode = False
bookList.Close False
Next n
Application.ScreenUpdating = True
End Sub
On Monday, 5 January 2015 12:26:39 UTC+3, Z
in advance.
Regards,
Zafar Iqbal
--
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
Format of B5:D5 is TEXT and B7:D7 is General. If Both rows will have same
formats then you will get same answer & visa vera.
On Wednesday, December 24, 2014 2:50:56 PM UTC+3, amar takale wrote:
>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:
Dear Expert,
You did an excellent job for me. Thanks you very much for this kindness and
I hope for the same support in future, always.
Regards,
Zafar Iqbal
On Tuesday, December 23, 2014 5:09:05 PM UTC+3, Vabz wrote:
>
> Hi
>
> Try this.
data is
coming in active work book. How to fix this problem. Please help. Thanks
On Tuesday, 23 December 2014 12:33:13 UTC+3, Vabz wrote:
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Dec 23, 2014 at 3:01
p).Offset(1, 0).PasteSpecial
> Application.CutCopyMode = False
> bookList.Close
> Next n
> Application.ScreenUpdating = True
>
> MsgBox "Done!!"
>
> End Sub
>
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
ugh me for you.*
>
> On Tue, Dec 23, 2014 at 12:40 AM, Zafar Iqbal wrote:
>
>> Dear Vaibhav Joshi, I checked it and found it working till selection of
>> Folder after that it is stuck at line Set filesObj = dirObj.Files .Please
>> help to fix this error mentioned below. Than
Dear Vaibhav Joshi, I checked it and found it working till selection of
Folder after that it is stuck at line Set filesObj = dirObj.Files .Please
help to fix this error mentioned below. Thanks
Run-time error '438':
Object does not support this property or method
Regards,
Z
p enabling choose any
folder within driver & select single or multiple excel file for processing
by code. I think that if Application.GetOpenFilename(filefilter:="Excel
Files (*.xl*), *.xl*",MultiSelect:=True) is used properly it will give this
flexibilty. Please help. than
Now, It is working excellent. Thanks for this great help, dear experts.
---
On Mon, Dec 22, 2014 at 1:32 PM, Vaibhav Joshi wrote:
> Try this...Removed some bugs, now its working good...
>
> Cheers!!
>
> +
> *I did not do this for yo
tps://www.facebook.com/VBAEXCELSQL?ref=hl
>
>
>
>
>
> On Monday, December 22, 2014 12:32:37 PM UTC+5:30, Zafar Iqbal wrote:
>>
>> Dear Experts,
>> Below mentioned code is to copy data from Sheet1 of all files at
>> specified location and paste in active Sheet.
Right now, I tried it and getting error message. Let me check possible
corrections at my end. Thanks for this kindness.
Regards,
ZAFAR IQBAL
---
On Mon, Dec 22, 2014 at 12:19 PM, Vaibhav Joshi wrote:
> Dear Ashish
>
> You
Dear Vaibhav Joshi, all files are with extension xls. If code will
temporarily or permanently do something with extension, it is no harm to
me. I can handle both .xls and .xlsx without any difficulty. Thanks
Regards,
ZAFAR IQBAL
---
On
w forum rules & send you
response ASAP. Thanks
Regards,
ZAFAR IQBAL
---
On Mon, Dec 22, 2014 at 11:25 AM, Vaibhav Joshi wrote:
> Hi
>
> You did not acknowledged response on last Query!!
>
> Read rule # 4) Acknowl
you.*
>>
>> On Mon, Dec 15, 2014 at 6:23 PM, Vaibhav Joshi > > wrote:
>>>
>>> Yes, you need to rotate picture first & then insert..
>>>
>>> http://stackoverflow.com/questions/21001667/rotate-a-saved-image-with-vba
>>>
>&g
If there is no short cut then I will follow your suggestion. Thanks for
your guidance.
On Sunday, December 21, 2014 11:16:34 AM UTC+3, Vabz wrote:
>
> Try to open file one by one using macro n save it as macro free workbook
> . Xlsx
>
> Cheers
> On Dec 21, 2014 1:0
Dear Experts,
Below mentioned code is to copy data from Sheet1 of all files at specified
location and paste in active Sheet. For regular up-dation on weekly basis,
it is needed to make this macro flexible with use of ADO Connection. It
will allow us to choose required folder, select one or more
these
closed files? Thanks for your guidance in advance.
Regards,
Zafar Iqbal
--
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
Dear Expert, You did an excellent Job. Thanks for it.
On Wednesday, 17 December 2014 15:41:22 UTC+3, Vabz wrote:
>
> hi
>
> can you share your experience with us?
>
>
> +
> *I did not do this for you. God is here working through me for you.*
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce
Dear Experts,
I got a Excel macro to paste pictures in Excel cell comments. It is working
fine. Now, I need a change in it. Pictures should be rotated 270 degree &
then pasted in cell comments. Can anybody help, please? Thanks in advance.
code is mentioned below:-
Sub InsertPictures()
Dim cll
h sign !
otherwise with sign x. Main bottle neck is copy paste of this conditional
formatting from one cell to many other cells. Thanks for your help in
advance.
On Saturday, 8 February 2014 07:49:00 UTC+3, Zafar Iqbal wrote:
>
> Dear Experts,
>
> In Excel version 2007, I am trying to get cond
ks
Regrads,
Zafar iqbal
On Jan 23, 7:35 pm, "dguillett1" wrote:
> Oops. I also should have added this to change formulas to values before copy
>
> sheets(“sheet1”).usedrange.value=sheets(“sheet1”).usedrange.value
>
> Don Guillett
> SalesAid Software
> dguille...@gma
Sir, Thanks for it. Just please guide me about i, lr, lc and mf. I
think that first three are to be defined as integer. What will be mf?
macro will run when we define these items.
Regards,
Zafar Iqbal
On Jan 23, 6:07 pm, Sam Mathai Chacko wrote:
> Zafar, your numbers are all coming correct.
We have to define i, lr, lc and mf. I tried with Dim i as integer, Dim
lr as Inetger, Dim lc as Integer. But what is mf? I do not know.
Please help. Thanks
On Jan 23, 5:26 pm, "dguillett1" wrote:
> Finds last row and last column and formats range and copies sheet1 to new
> book without formulas.
Sir, Now, graph table is more correct.
Last thing remaining is date format in graph. Right now, In graph
table, date format (23-Jan) is converted to number format (40931). I
need 23-Jan instead of 40931.
Regards,
Zafar Iqbal
On Jan 23, 4:57 pm, Sam Mathai Chacko wrote:
> Well, this should ro
new file figures in graph table are again not upto 2 decimals. File
is attached. Please help. Thanks
Regards,
ZAFAR IQBAL
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem
to
paste special FORMAT on graph.
Please help. Thanks
Regards,
Zafar Iqbal
On Jan 23, 4:01 pm, NOORAIN ANSARI wrote:
> Dear Zafar,
>
> First copy and value paste in New Sheet..
> Again copy and Select data of new sheet and Format paste .
>
> Hope it will help to you.
>
&g
will permanently round data to 2
decimals in Sheet + Chart and it will not disturb cells having text values
coming from Hlookup, Index, etc.
Thanks for your guidance, in advance.
Regards,
ZAFAR IQBAL
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
Dear Expert,
Will you please explain why to mutiply date value with 100?
Regards,
Zafar Iqbal
On Thu, Sep 15, 2011 at 2:53 PM, §»VIPER«§ wrote:
> hi
>
> pfa
>
>
> --
> *Great day,*
> *viper*
>
--
Dear Experts,
Will somebody inform me that why my request is not getting your kind
attention, please?
Regards,
Zafar Iqbal
On Mon, Sep 5, 2011 at 11:00 AM, Zafar Iqbal wrote:
> Dear Experts,
>
> Still waiting for your kind support.
>
> Regards
Dear Experts,
Still waiting for your kind response.
Regards,
Zafar Iqbal
-
On Mon, Aug 29, 2011 at 12:59 PM, Zafar Iqbal wrote:
> Dear Expert,
>
> One last thing to remind that Color bar should increase or decrease when
> duratio
Dear Expert,
One last thing to remind that Color bar should increase or decrease when
duration is changed. Please help in this matter with Excel logical formulas
& conditional formatting, only. Try to avoid VBA, if possible. Thanks
Regards,
Zafar Iqbal
On Mon, Au
Dear Experts,
I am still waiting for reply from you all. Please help me in this matter.
Thanks
Regards,
Zafar Iqbal
On Sat, Aug 27, 2011 at 10:29 AM, Zafar Iqbal wrote:
> Dear Expert,
>
> Ref your instructions, please find attached file with conditional
> formatting applied.
Dear Group,
How to attach Excel file here in this post? I cannot find any button
for attaching files here in this page. Please help. Thanks
Zafar Iqbal
--
--
Some important links for excel users:
1. Follow us on
Dear Mr. Fabio Lemos,
I replaced ; with , and got the result. Thanks for this short formula.
Please discard my previous e-mail for sample file. Thanks
Regards,
ZAFAR IQBAL
From: Zafar Iqbal [mailto:ziqba...@gmail.com]
Sent: Sunday, May 15, 2011 10:15 AM
To: 'Fabio Lemos'
Dear Mr. Fabio Lemos,
Thanks for your interest.
I tried to apply your below mentioned formula. I am getting error message.
Can you please send me sample file with formula. Thanks a lot for this
kindness.
Regards,
ZAFAR IQBAL
From: excel-macros@googlegroups.com [mailto:excel-macros
scroll bar
should be 63.
If A2 is Catering and Hospitality, Max value of scroll bar
should be 20.
This is avoid Zeros coming in cells when scrolling down beyond 20 or 46 for
second & third sheet data.
Regards,
ZAFAR IQBAL
Mobile: 0556 014 035
From: excel-ma
Dear, With due respect to your effort, I tried with a simplified formula and
got the same result. Please the attached file with both formulas. Thanks
Regards,
ZAFAR IQBAL
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of §»VIPER«§
Sent: Thursday, May
Excellent formula. Well Done.
Regards,
ZAFAR IQBAL
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sixthsense
Sent: Friday, May 13, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to change Date format
Hi Prabhu,
Try
Dear Mr. Rohan,
Please check the attached file (formula in red font), if it fulfills your
needs.
Regards,
ZAFAR IQBAL
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rohan Young
Sent: Tuesday, May 10, 2011 8:48 AM
To: excel-macros@googlegroups.com
Dear Mr. Andre,
Thanks for this help. I observed that this macro will not work if the file
is closed without SAVE. How to rectify this matter? I request that file
should be discarded just after 4 times open independent of Save or No Save.
Thanks
Regards,
Zafar Iqbal
2011/4/27 André D'
Dear All,
Can someone help in making a macro which will make the Excel file expired
after few tries of open & close. For example, file can be opned, saved &
closed for four times but this file should not open after 5th time to open.
Please help. Thanks
Regards,
ZAFAR IQBAL
Incharge
65 matches
Mail list logo
