Dear Ashish,
Thanks for the reply. The names will be unique.
Thanks
On Sun, Aug 4, 2013 at 9:25 PM, ashish koul koul.ash...@gmail.com wrote:
are the names unique ? or will one person have multiple status on diff
dates?
On Sun, Aug 4, 2013 at 7:59 PM, KATHIRVELAN N
Hi Umar Abeer,
Its very simple if ur company want to terminate u, then u can use this
macro in master data :-)
am just joking...
I thought this would be a great security feature for an annual subscription
feature I have on my site. Ideally the spreadsheet would lock or a password
would be
WELCOME EVERYBODY... :-)
Regards
Kannan.Excel
On Sun, Aug 4, 2013 at 2:23 PM, priti verma pritiverma1...@gmail.comwrote:
Most Welcome Niraj
On Sat, Aug 3, 2013 at 11:31 PM, xlstime xlst...@gmail.com wrote:
Welcome Niraj
.
Enjoy
Team XLS
On Sun, Aug 4, 2013
nice info
On Thu, Aug 1, 2013 at 7:27 PM, ashish koul koul.ash...@gmail.com wrote:
visit this link for more intersting facts
http://office.microsoft.com/en-in/excel-help/excel-specifications-and-limits-HP010073849.aspx
On Thu, Aug 1, 2013 at 6:46 PM, Amit Desai (MERU)
There are tools available to pick-up/trace points on a picture of a plot.
One such tool is Enguage Digitizer (http://digitizer.sourceforge.net/). It
is free and quite useful.
Many engineers use it to convert a old research chart into numbers so that
they can compare latest results with the old
Hello All,
I've reviewed all replies. Can we do following things ?
After opening excel, Sheet1 only should get open !
On sheet1, we can write that Without Enabling macro facility this
excel will not work.
Can we prepare macro which will keep all fonts cells in white color ?
I can't say,
Dear Friends,
Please help me to get this answer.
Thanks,
Kathir
On Mon, Aug 5, 2013 at 11:31 AM, KATHIRVELAN N nkathirv1...@gmail.comwrote:
Dear Ashish,
Thanks for the reply. The names will be unique.
Thanks
On Sun, Aug 4, 2013 at 9:25 PM, ashish koul koul.ash...@gmail.com wrote:
are
Wow Great VBA sorry for replying late, but this is great. Just a little
adjustment i realized you were dividing it by the sum total of the capital
gains, it should rather be dividend by the market value instead for the %
of equities , however the % of portfolio should be the total of the
equities
Dear I am making a small error in my file, only one condition is working in
VBA, Please give me tips to complete it
Awaiting your answer
RegardsSajid Memon
--
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) !
Respected Kathirvelan,
What exactly is ur requirement.For example, To sort the data or to get the
approved or not approved status on a particular date etc.if your
reuiqrement is not clear then members will not be able to help you.
Regards,
Vijaykumar
On Mon, Aug 5, 2013 at 2:21 PM, KATHIRVELAN
Respected Kathirvelan,
Pivot table sigma values box should contain only numerical data and not
text data.you can use a normal table instead and use Vlookup or the INDEX
and MATCH functions to get the desired results.
Regards,
Vijaykumar
On Mon, Aug 5, 2013 at 3:01 PM, P.VIJAYKUMAR
I tried to understand your code but couldn't. However, see if the attached
helps.
Thanks,
On Mon, Aug 5, 2013 at 2:56 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear I am making a small error in my file, only one condition is working
in VBA, Please give me tips to complete it
Awaiting
Respected Kathirvelan,
Please check the following link for your solution.
http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba/
Regards,
Vijaykumar
On Mon, Aug 5, 2013 at 3:11 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Kathirvelan,
Pivot table
Try this
Private Sub CommandButton1_Click()
Dim Rng As Range
For Each Rng In Range(C1:C20)
If Rng Then Rng.Offset(, 2) = IIf(Left(Rng, 1) = `,
Tax, Retail)
Next
End Sub
Pada 05/08/2013 16:26, SAJID MEMON menulis:
Dear I am making a small error in my file, only one
Thank you. That is what I suspected, but my client is certain that this is
not so. This confirms what my thoughts were.
Thanks again,
Olivia
On Sun, Aug 4, 2013 at 5:44 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Yes, You can make a chart by using a sample of data but the reading of
chart
Hi experts,
Does anyone have a VBA script to convert excel files that can define a
structure to be exported into a json format
--
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 @
No you cannot convert vba lang to JSON format.
Microsoft Development team is already working on it. This is been
identified and will be ready with Microsoft Office 2015 version.
On Mon, Aug 5, 2013 at 9:31 PM, Mog Godiva-Man osaze...@gmail.com wrote:
Hi experts,
Does anyone have a VBA script
Hi,
I have a macro written that will check if a value in column X matches a
specified value, if it does the row gets copied onto another tab and then
the macro keeps looping to evaluate all the rows. However, when cell A# is
blank, but there's data in the rest of the cells in that row the
But is there a customize VBA that can write it in to Json format
On Aug 5, 2013 12:20 PM, yogananda muthaiah yogananda.mutha...@gmail.com
wrote:
No you cannot convert vba lang to JSON format.
Microsoft Development team is already working on it. This is been
identified and will be ready with
Ooh Vabs you rock. One more request. Can I have a portion of your brains that
works the VBA solutions. Jus a lil part. Thanks mate. Excellent work
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: vba v...@vabs.in
Sender: excel-macros@googlegroups.com
Date:
I dont know is that exist, but after reading a while about JSON Format,
i think we can do some simple translation on Excel Data to something
looklike bellow
{
Sheet1: {
title: Your Sheet Name Here,
Data: {
Row1: {
Name: De Premor,
Pretty much that's exactly what I need to do. Would it be helpful if I
provided a sample file?
Regards,
Godiva.
On Mon, Aug 5, 2013 at 3:47 PM, De Premor d...@premor.net wrote:
I dont know is that exist, but after reading a while about JSON Format,
i think we can do some simple translation
That would be great we have a sample file and what you need to do with it (what
data you need to be exist on json data)
-Original Message-
From: Mog Godiva-Man osaze...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 5 Aug 2013 18:43:34
To: excel-macros@googlegroups.com
Check this page http://www.mcpher.com/Home/excelquirks/json
See if it helps
Regards
Ashish
On Tue, Aug 6, 2013 at 7:23 AM, De Premor d...@premor.net wrote:
**
That would be great we have a sample file and what you need to do with it
(what data you need to be exist on json data)
Can u share a sample file
On Mon, Aug 5, 2013 at 10:50 PM, Geoff intaminfan...@gmail.com wrote:
Hi,
I have a macro written that will check if a value in column X matches a
specified value, if it does the row gets copied onto another tab and then
the macro keeps looping to evaluate all the
I am trying to make a macro that deletes a row in a column if it detects a
specific word or phrase from a set of phrases.
Friendly's
Ruth's Chris Steak House
Hooters
Ruby Tuesday
Chili's Grill Bar
etc.
I have searched for HOURS to find an answer and have tried combining code
from other
Dear Team,
I have dates in different format and need to make it in one standard date
format. Please help me to fix this.
Rgds,
Prabhakar
--
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 @
27 matches
Mail list logo