Ashish Sir,
Thank you.
This is working. You have solved my big problem.
With Regards,
*Suyog*
On Wednesday, 3 July 2013 20:23:41 UTC+5:30, ashish wrote:
>
> try this macro see if it helps
>
> Sub add_comboboxes()
>
> Dim rng As Range
> Dim cl As Range
> Dim shp As Shape
>
> For Each shp In A
Thank you so much Abhishek ji, it's working fine.
On Thu, Jul 4, 2013 at 11:51 AM, Abhishek Jain wrote:
> PFA
>
>
> On Thu, Jul 4, 2013 at 11:42 AM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
>> Dear Experts,
>> I want Result on conditions.
>> Pls find the attachment.
>>
>> --
>>
PFA
On Thu, Jul 4, 2013 at 11:42 AM, Rakesh Kumar Sharma wrote:
> Dear Experts,
> I want Result on conditions.
> Pls find the attachment.
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =T
Dear Experts,
I want Result on conditions.
Pls find the attachment.
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
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
Hi Anoop
I do not want to restrict my folder from unnecessary access instead I want
it to be used by others.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Anoop K Sharma
Date: Thu, Jul 4, 2013 at 5:36 AM
Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
T
Thanks Vijay for sharing different charts. it will help a lot.
With warm regards,
Rajan Sharma
On Wed, Jul 3, 2013 at 10:51 PM, P.VIJAYKUMAR wrote:
> Respected Waseem,
>
> please have a look at these charts.
>
>
> Regards,
> Vijaykumar
>
>
> On Wed, Jul 3, 2013 at 3:45 PM, Waseem Saifi wro
Dear All,
I am new to VBA programming
I happen to need great and urgent help on a project that I am currently
working on
I would like to search through the worksheet, and find "N" or "TR" on row 6
Then, For every cell in the column of "N" or "TR"
if all the cells are blank, then delete/ hide the
you can use = text(cell,"dd mmm "), this will give time in text format.
On Thu, Jul 4, 2013 at 3:17 AM, srsev6 wrote:
> Hi all,
>
> I have already posted this once but can not locate it so I apologize for
> the duplicate post.
>
>
> I hope someone can answer my question. I run dates out of
If you right click on any folder and check its properties, there you can
see a security tab.
If you are an administrator or have administrator's right then you can
restrict your folder from unnecessary access. This can be done on the
folder in shared shared drive.
On Wed, Jul 3, 2013 at 5:27 PM,
Hi all,
I have already posted this once but can not locate it so I apologize for
the duplicate post.
I hope someone can answer my question. I run dates out of a database which
uses access. The dates I pull out have a timestamp. The timestamp hinders
my formulas in my excel spreadsheet
I pull information out of an Access database. When I copy and paste or
export to excel the dates have a timestamp. This hinders many of my
formulas I use. Is there a macro that I can use in a template that will
remove the timestamp and leave the date. Right now, I am using the formula
=int(
Thanks for the reply.
2013/7/3 Waseem Saifi
> Dear Van,
>
> I have placed a formula in first sheet in K column.
> it might help you.
>
>
> On Mon, Jul 1, 2013 at 12:47 AM, Bé Trần Văn wrote:
>
>> Question 1: I need one function to the column numbered F.
>>
>> Question 2: In column J, How to con
try the attachment . if ur data is in lakhs best is u use access
Regards
Ashish
On Wed, Jul 3, 2013 at 8:42 PM, SG wrote:
> hi Ashish,
>
> The data is in lakhs & advance filter would allow me to filter only one
> criteria.I have atleast 4 filters in this data.
> plz experts help me with a ma
hi Ashish,
The data is in lakhs & advance filter would allow me to filter only one
criteria.I have atleast 4 filters in this data.
plz experts help me with a macro.
On Wednesday, July 3, 2013 8:29:18 PM UTC+5:30, ashish wrote:
> u can do it using advance filter
>
>
> On Wed, Jul 3, 2013 at 7:5
*Front End : 4 Positions*
*Back END : 2 Positions*
*Location : Dallas,TX*
*Duration : 1+ yrs*
*Interview : Skype or In Person*
*Prefer Local / Far situated are also acceptable*
*Developer (Front End & Back End)*
· UI – jsp/html (5),
· Java, junit
· SQL/RQL from
u can do it using advance filter
On Wed, Jul 3, 2013 at 7:55 PM, SG wrote:
> thanx for the response.
>
> PFA example.What i want is to filter the data as oer the "Form" sheet &
> extract name & it's accuracy & paste in the data section.the data is so
> huge that's why i want it by macro.
>
> On
try this macro see if it helps
Sub add_comboboxes()
Dim rng As Range
Dim cl As Range
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
If shp.Type = msoFormControl Then shp.Delete
Next
Set rng = Range("b3:b10")
For Each cl In rng
ActiveSheet.DropDowns.Add(cl.Left,
Hello Friends,
I need help in building a code that enables me to export rows from Excel
worksheet to a SharePoint list.
Please see attached. I inserted a button. Once the button is clicked, data
in row 2 should copy over to SharePoint list. On the SharePoint list a new
item should be appended.
thanx for the response.
PFA example.What i want is to filter the data as oer the "Form" sheet &
extract name & it's accuracy & paste in the data section.the data is so
huge that's why i want it by macro.
On Wednesday, July 3, 2013 7:41:24 PM UTC+5:30, Vabz wrote:
> HI
>
> Pl share sample fil
thank you bro
On Wed, Jul 3, 2013 at 3:00 PM, Waseem Saifi wrote:
> Dear Thameem,
>
> Open attached file. I have applied rule what you have asked.
> just select from cell A2:C4 and go to conditional formatting-manage rules.
> It will be cleared.
>
>
> On Sat, Jun 22, 2013 at 2:56 PM, thameem w
HI
Pl share sample file.
Thanks
On Wed, Jul 3, 2013 at 7:30 PM, SG wrote:
> Hi Experts,
>
> I want to create a report in which data would be extracted on basis of
> atleast 4 filters from base data sheet.please help me with a macro example.
>
> Thanks in advance.
>
> --
> Are you =EXP(E:RT) o
Hi Experts,
I want to create a report in which data would be extracted on basis of
atleast 4 filters from base data sheet.please help me with a macro example.
Thanks in advance.
--
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
Dear...
Search the youtube or just google it with the keywords that you have posted
here in the group you shall get plenty of examples and videos to
understand you will find helping yourself...
On Wed, Jul 3, 2013 at 4:20 PM, Vijay Kr. Aggarwal wrote:
> I want to know that can we use
Dear all,
Does anybody have AMC Tracker Template/Sheet ?
Regards
--
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
I want to know that can we use function like Sum, Count Max and Min in
Calculated field? If yes please provide me examples.
thanks in advance.
On Tue, Jul 2, 2013 at 7:43 PM, Vijay Kr. Aggarwal wrote:
> Hi Experts,
>
> I want to know the Functions name, which we can use in Calculated field of
Hello All,
I've created one form control & copy and paste them all the way down the
column, hoping that the linked cell will get auto update like normally
happens while copy-pasting of any normal formula. Now I've to set all
individually set up the cell link for each one.
Is there anyway of c
*Point No. 1*
Please note, in my office computer I have stored a folder (which contains
only “xlsb” files) in my roaming profile id; which need to be shared with
some other colleagues in the same office. But there no privilege for
sharing from one computer to another computer in our office. Hence
Hi Abhishek,
Regardless of the number of digits displayed,
Microsoft Excel stores numbers with up to 15
digits of precision. If a number contains more
than 15 significant digits, Microsoft Excel
converts the extra digits to zeros (0).
Please go through the below link :
http://support.mi
Dear Thameem,
Open attached file. I have applied rule what you have asked.
just select from cell A2:C4 and go to conditional formatting-manage rules.
It will be cleared.
On Sat, Jun 22, 2013 at 2:56 PM, thameem wrote:
> Dear all,
>
> Plz find attached file, its sample, I want high for range of
I think Pie chart only made for Percentage type data.
for example Pie chart require a data which's percent total is 100%. if
a=45%, b=30%, c=25%. then it will give right output.
all in all pie chart not suitable for other than percentage type data. and
that data's total should be 100% or in general
But how it's getting changed automatically?
-- Forwarded message --
From:
Date: Mon, May 6, 2013 at 4:31 PM
Subject: Re: $$Excel-Macros$$ 8 become 0
To: excel-macros@googlegroups.com
**
Change the format of cell to text or add ' in front of number
Sent on my BlackBerry® from Vo
31 matches
Mail list logo
