hi friends i need small help from you guys. i have attached the excel sheet,
in which at the end of the sentence i
want to add the Month and year of the next coming month.
please help me out
--
Sidhu
--
--
Some impor
use code() function in the worksheet
or use the following function to get the ascii value of each character
seperated by a space
Public Function GetAscii(Var)
Dim Cd As String
For x = 1 To Len(Var)
Cd = Cd & IIf(Cd = "", Trim(Str(Asc(Mid(Var, x, 1, " " &
Trim(Str(Asc(Mid(Var, x, 1)
Next x
Hi Team,
The password is correct "STPIInvoices" in this up to STPII is CAPS letter
nvoices is small latters.
Please let me know if you have any questions on this.Thanks in advance.
*Private Sub cmdPrint_Click()
Set objDataSheet = Me.Parent.Sheets("Data")
objDataSheet.Unprotect "STPIInvo
Hi,
In H4 enter:
=IF(G4=0,"",D4/G4)
And similarly for other cells that contain a division operator
Basically we are saying, if the denominator = 0 then nothing, otherwise, do the
math.
Regards - Dave.
Date: Wed, 28 Jul 2010 21:08:00 +0300
Subject: $$Excel-Macros$$ Help: Creating fo
Hi,
My guess is that PROCV is a formula saved by that name.
Check out: Insert | Name | Define
Regards - Dave.
> Date: Wed, 28 Jul 2010 16:41:04 -0700
> Subject: $$Excel-Macros$$ Re: dont understand sintax...newbie!
> From: dlanm...@att.net
> To: excel-macros@googlegroups.com
>
> Hi,
>
> I h
Hi,
=CODE(MID(A2,3,1))
Where cell A2 has your data, and you want to examine the 3rd character.
Regards - Dave.
> Date: Wed, 28 Jul 2010 10:48:35 -0700
> Subject: $$Excel-Macros$$ How to see the ascii code of a text withing a field
> From: gals...@aol.com
> To: excel-macros@googlegroups.
Hi,
I have never heard of PROCV, so I am interested in this too.
David
On Jul 28, 4:18 am, x-plicit wrote:
> Hello All,
>
> I do not understand this sintax:
>
> =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D
> $13152)));$K$1:$L$6;2;true)
>
> Could someone help me out?
--
Is there a way to see what the ascii code is for each character in a
chosen field?
The reason is, I got a file from China that contain some characters
that on xls they look as "space", but when I do "replace space by
nothing" this "space" is still there. so I assume it is not really a
space charact
I have an Excel workbook w/ a VBA menu to pops up a userform to write
values back to a worksheet in the workbook. Sometimes, the userform
locks Excel and it has to be abended. I suspect its due to users have
other workbooks open and copying and pasting between them. Can I
specify a specific instan
On Jul 28, 7:18 am, x-plicit wrote:
> Hello All,
>
> I do not understand this sintax:
>
> =PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D
> $13152)));$K$1:$L$6;2;true)
>
> Could someone help me out?
Google implies you've got a Portuguese version with =procv() being
either v
Thanks Kishan for your reply. However, it's not exactly what I'm
looking for.
If you take a look at the worksheet I downloaded, "Net Sales
Chart.xls", I would like to do the following:
1. Under the "Select the period to plot" drop down menu, I'd like
to select the appropriate month rather tha
Hi Team,
I have a challenge, how can I create a formula using VBA?!
Attached file show details, but i don't want to see *#DIV/0! *error in case
columns used in division does not have any data!!
column E - F = column G (sometimes column E - F does not have any data, so i
don't want to see 0 in c
Using an approximate match, find the largest value in (B3 * C3 * each
cell in D3:D13152) located in range(K1:K6) and return the
corresponding value in range(L1:L6)
google indicates you've got a Portugese version of Excel, with
=procv() being either =vlookup().
standard layout is VLOOKUP (lookup_v
Dear All,
Please find attach the sheet wherein I need the Data from "Tracking Sheet"
should go the each individual sheets the data.
Please see attach file for more understanding.
Waiting for your ideas and suggestions...
--
Ahmed Bawazir
--
---
Hi experts,
We have macro to extract the subject line from outlook mail folders..
It used to work ok..But for some reason now it errors out on this line:
*Set ns = Application.Session*
iGrandRow = 2
Set wsCsd = wb.Worksheets(Tabnum1)
And here is the error messege:
“Object doesn’t
Hello All,
I do not understand this sintax:
=PROCV(sumproduct(max(($B$3:$B$13152=B3)*($C$3:$C$13152=C3)*($D$3:$D
$13152)));$K$1:$L$6;2;true)
Could someone help me out?
--
--
Some important links for excel users:
1
Yes sir
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Vasant
Sender: excel-macros@googlegroups.com
Date: Wed, 28 Jul 2010 15:27:53
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help
Do u want the data in ms-word as a paragraph ?
On 7/28
Do u want the data in ms-word as a paragraph ?
On 7/28/10, madha...@yahoo.com wrote:
> Dear expert
> I have some data stored in excel sheet and I wanted to convert the same in
> paragraph form can I know how can I convert the same in paragraph form.
>
> Warm regards
>
> Madhav Vyas
> Sent on my B
The spreadsheet can be found in the files section and is titled "Net
Sales Chart.xls".
Steve
On Jul 27, 7:43 pm, Steve wrote:
> I need help!
>
> I am trying to adapt a neat little spreadsheet for my use in graphing
> monthly, quarterly, and year-to-date sales for the current year and a
> compar
You're welcome.
Regards - Dave.
> Date: Wed, 28 Jul 2010 00:05:02 -0700
> Subject: Re: $$Excel-Macros$$ trouble with multiple formulas
> From: nkmorri...@hotmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave,
>
> THANK-YOU so much, you formula works a treat. It's taking a little
> while
Hi,
The cells in currency format will most likely be numeric. So if your data
starts in cell A2, place the following formula in B2, then copy down:
=If(ISNUMBER(A2)=TRUE,A2,"")
Regards - Dave.
> Date: Tue, 27 Jul 2010 09:42:17 -0700
> Subject: $$Excel-Macros$$ Remove selected
Code is not opening, The password might be wrong.
Kishan Reddy, K
On Jul 27, 10:21 am, Nagendra Modupalli wrote:
> Hi Team,
>
> I have Invoices printing macro.It is printing row wise.I want to modify
> customer wise.Can you please help me.Thanks in advance.
>
> And also i have attached my macro
use the following formula in adjucant cell.
for example if your data is in column B2 then in C2 copy and paste the
following formula.
=RIGHT(B2,LEN(B2)-FIND("$",B2)+1)
once you got all the values in column C
1. copy the contents in column C
2. use Edit -> Paste special - values to paste them ba
Hi Dave,
THANK-YOU so much, you formula works a treat. It's taking a little
while like you said, but it's worth it.
Kind Regards,
Narelle
On Jul 27, 6:55 pm, Dave Bonallack wrote:
> Hi,
>
> Have a look at the attached to see if it does what you need.
>
> If you have 170,000 rows, that means 170
Why can't you use pivot table or subtotals commands instead of
formulas
Regards,
Kishan Reddy, K.
On Jul 27, 10:29 am, "nkmorri...@hotmail.com"
wrote:
> Can anyone provide me the formula/s for below query? I have four
> columns. Company, Product, Date and Weight. What I need to do is add
> up th
Instead of storing the macro in personal macro workbook, select this
workbook.
There may a problem with the personal work book.
Regards,
Kishan Reddy, K
On Jul 27, 1:10 pm, Rehan Baig wrote:
> Dear Members
>
> I have some problem with macro recording,
>
> after entering macro name, shortkut k
Just use sort command, vlookup function & filter commands, done
sort the data in sheet2 on id.
add another column besides ID. and place 1 in the columns
in sheet 1, Add another column (Example in D) to sheet1 and name it as
index (assuming data is in columns A B C)
use the following formula in D
Hello,
Obviously you will have a data sheet on which you have created the
graph.
Just right clik on the graph and select source data
It will show the data on which graph is drawn.
Just reselect the range that you want and press OK
done.
Bye
Kishan Reddy, K.
On Jul 28, 4:43 am, Steve wrote:
flebber wrote:
> I have a column containing cells which house several delimited values
> and a dollar value. I want to be able to remove the delimited values
> and leave the dollar value in the cell in currency format.
>
> the cells contain information similar to
>
> 22-7-4-7 $22400.10
If this tex
Dear expert
I have some data stored in excel sheet and I wanted to convert the same in
paragraph form can I know how can I convert the same in paragraph form.
Warm regards
Madhav Vyas
Sent on my BlackBerry® from Vodafone
--
--
30 matches
Mail list logo
