If you want enter any text, which looks like a formula or a number use
' (Single quote, this key can be locoted beside the enter key on the
keyboard)
If you want enter a + symbol, type '+ in the cell.
This feature is inherited by excel from old spreadsheet program Lotus
123.
Also there are some
Dear Haseeb,
Superb !!! Its working perfectly :-)
Can you please exlain me on what is 9e+300 used for ???
cheers
JP.
On Sat, Nov 12, 2011 at 12:47 AM, Haseeb Avarakkan
wrote:
> Hello JP, Please do not post multiple thread for the same query.
>
> In Summary B4, copy down & across.
>
> =LOOKUP
Can you provide the format of your data.. Also want to know do you outlook
to send emails..??
On Sun, Nov 13, 2011 at 10:30 PM, maulik desai wrote:
> Hi Team,
>
> I am having 1 excel sheet in that i have to prepare Chennel wise detail
> report on a every week & i have to send that information to
A most excellent solution..
Ken
On Oct 23, 5:44 pm, anandydr wrote:
> Hi,
>
> One simple method would be to incase your formula in and IF formula
> which can put NA( ) instead of zero. e.g.
> =IF(COUNTIF(A1:A100,"T")=0,NA( ), COUNTIF(A1:A100,"T"))
>
> Excel would not plot NA in the chart
Dear Sam,
Its working in the excel file attached..but its not working in other file
how should I do..
The modified script is as below, is it correct?
Sub GetListOfSheets()
Dim lng As Long
Worksheets("..Sorter..").UsedRange.ClearContents
For lng = 1 To Sheets.Count
If lng <>
Hi Team,
I having 1 excel sheet in that i have apply below Sumproduct macro code 72
times to get output on my database (This code is provided by Daniel of this
group ) my But my problem is it take about 20 to 30 mins to run the code
total 550 row(not fixed) x 72 columns ) what I want that can i ge
Hi Team,
I am having 1 excel sheet in that i have to prepare Chennel wise detail
report on a every week & i have to send that information to respective
chennel heads wia email ,
Manually i need to do filter the data base on chennal name & then copy data
from sheet & need to paste on mail body then
There is a sheet by the name ..Sorter..
In the first column of the sheet you can get the list of all sheets in
the workbook by clicking on the first button. in the next column, you
have to type the new names of those sheets. then click on the 2nd and
3rd buttons.
I could have added a line in the f
Thanks.. but I am getting some error..
While renaming, I am getting an error "500" & some time "out of range".
Where should I paste the data for newssheet name?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sam Mathai Chacko
Sent: 13 November 2011 23:0
Thanks...this helps changing the name of sheet all at once...but..I need 3
things,
1) List the names of work sheet in one black sheet of the file,
2) Change the name of worksheet all at once (have a macro),
3) Arrange the worksheet either alphabetically or as needed (have a
mac
If it is not for very many pdf files, a converter could be used like the
one here
http://www.pdftoexcelonline.com/
Regards,
Sam
On Sun, Nov 13, 2011 at 9:14 PM, sharad jain wrote:
> Hi All,
>
> I have PDF containing record of more 200 companies and running into 35
> pages into the form of tab
Hi All,
I have PDF containing record of more 200 companies and running into 35
pages into the form of table.
I am using the free version of PDF.
Is there any way that I can import the table into excel.
Thanks,
Sharad
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise,
Excellent,
Thanks you so much both of you,
I am little confused about Mr.Sam's first solution due to its named ranges,
its a new knowledge to me, I will try to understand.
Thanks again both of you.
On Sun, Nov 13, 2011 at 6:13 PM, Sam Mathai Chacko wrote:
> I'd recommend keeping the method
I'd recommend keeping the method safe by relying only on the source data.
>From that echelon, I'd suggest using COUNTA to pass the column index in the
VLOOKUP argument, instead of referring to (an)other cell(s).
=VLOOKUP($I$3,$I$9:$M$13,COUNTA($I$8:I$8),0) for example can be dragged
across from co
See attached
Don Guillett
SalesAid Software
dguille...@gmail.com
From: kurikkal padinjarappalla
Sent: Sunday, November 13, 2011 4:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ To Set Dropdownlist in Chart
Dear All,
Could somebody help me by setting a drop down list for cre
Private Sub OptionButton1_Click()
With ComboBox1
.List = Sheet1.Range("D9:D11").Value
.ListIndex = 0
End With
End Sub
Private Sub OptionButton2_Click()
With ComboBox1
.List = Sheet1.Range("F9:F11").Value
.ListIndex = 0
End With
End Sub
Regards
Hi Group,
Please help me with the coding in the attached excel sheet.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Well done
On Nov 13, 11:25 am, Cab Boose wrote:
> Hi
>
> I would like to use the 'File-Open' command in Excel to bring in a pdf
> file and have it finish up in .xls format. Is there an add-in to do this
> automatically or a vba way to have it converted. Most of the on-line
> require the conver
My Excel 2011 is stopped always
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Do
Can be done using named ranges. Hit CTRL+F3 to find out how I named two
dynamic ranges for your data.
The ClientData for example was made like so..
=OFFSET(Sheet1!$J$8:$M$8,MATCH(Sheet1!$D$2,Sheet1!$I$9:$I$13,0),,1)
Regards,
Sam Mathai Chacko
On Sun, Nov 13, 2011 at 3:37 PM, kurikkal padinjara
Dear All,
Could somebody help me by setting a drop down list for creating chart, as
if I select a particular client name in drop down list it should appear the
chart of that particular client.
please find the attached sample sheet.
Thanks for your valuable solutions.
Regards,
Kurikkal.
--
FOR
Thanks.. this helped me in arranging it..but how to list & rename it..
say..Sheet A to become C, R to become S etc...
Regards,
Amit Desai
AM - MIS Corporate
Meru Cabs Company Pvt.Ltd
Mumbai
Mob:9867232534
[cid:image001.gif@01CCA20F.67710110]
From: excel-macros@googlegroups.com [mailto:excel-mac
Pl chk this,
http://support.microsoft.com/kb/812386
Cheers,
Andy
On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU)
wrote:
> Dear Master,
>
> ** **
>
> I have an excel file with sheet names ranging from A to V. However I want
> to change its sequence post changing its name.
>
> ** **
>
Dear Master,
I have an excel file with sheet names ranging from A to V. However I want to
change its sequence post changing its name.
Do we have any shortcut?
Regards,
Amit Desai
AM - MIS Corporate
Meru Cabs Company Pvt.Ltd
Mumbai
Mob:9867232534
[cid:image001.gif@01CCA209.4B1EB210]
_
24 matches
Mail list logo
