Thanks Sir.
On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA v...@vabs.in wrote:
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand
But how it's getting changed automatically?
-- Forwarded message --
From: koul.ash...@gmail.com
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
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 thamee...@gmail.com wrote:
Dear all,
Plz find attached file, its sample, I want
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 :
*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.
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
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 vjaggarwal2...@gmail.com
wrote:
Hi Experts,
I want to know the Functions name, which we can 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
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 vjaggarwal2...@gmail.com
wrote:
I want
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
HI
Pl share sample file.
Thanks
On Wed, Jul 3, 2013 at 7:30 PM, SG sonal...@gmail.com 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
thank you bro
On Wed, Jul 3, 2013 at 3:00 PM, Waseem Saifi waseemsa...@gmail.com 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
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 file.
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
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,
u can do it using advance filter
On Wed, Jul 3, 2013 at 7:55 PM, SG sonal...@gmail.com 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
*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
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:55
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 sonal...@gmail.com 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
Thanks for the reply.
2013/7/3 Waseem Saifi waseemsa...@gmail.com
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 betnmtdongna...@gmail.comwrote:
Question 1: I need one function to the column numbered F.
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
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
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,
you can use = text(cell,dd mmm ), this will give time in text format.
On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com 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
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 column
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 vijay.4...@gmail.com wrote:
Respected Waseem,
please have a look at these charts.
Regards,
Vijaykumar
On Wed, Jul 3, 2013 at 3:45 PM,
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 aks.sharm...@gmail.com
Date: Thu, Jul 4, 2013 at 5:36 AM
Subject: Re: $$Excel-Macros$$ Files / Folders
27 matches
Mail list logo