Hi All,
Need your help i want to create list, but not able to so as i m use Excel
2007 for 1st time.
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~~
-
Some important links for ex
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others
too.
Problem:It is very difficult to remember tones of figures
Solution: It is easier to remember nearest lower/higher figures
Formula/function required: If last tw
give an example. that would be gr8.
--- On Tue, 6/23/09, Pavan Kumar VVN wrote:
From: Pavan Kumar VVN
Subject: $$Excel-Macros$$ Excel Tip of Week # 26
To: excel-macros@googlegroups.com
Date: Tuesday, June 23, 2009, 12:46 AM
Hi,
Here's my contribution
If you have N/A or any other
Try this if it works
1. Add two columns of Party name and bill No with
formula =CONCATENATE(B7,C7) in both the sheets.
Party Name Bill no use formula
XYZ LTD 25 =CONCATENATE(B7,C7)
2.then try the VLOOKUP
if there is error in this vlookup after joining tw
Hi Pat:
May be you could look at http://ideas.repec.org/c/wpa/wuwppr/0302001.html
and Then possibly extend based on your requirements
Thank you,
Dev
On Jun 20, 5:09 am, Pat Sheehan wrote:
> Hi,I am looking to design a questionnaire via Excel with Yes/No options
> against the questions but als
Hems
I have aquestion on how to use your form.
I am just learing Excel. I made your form come up once from your sheet but I
can not make it come up again.
Thank you.
Don
From: Harmeet Singh
To: Hems ; excel-macros@googlegroups.com
Sent: Tuesday, June 23, 2009
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others too.
Problem:It is very difficult to remember tones of figures
Solution: It is easier to remember nearest lower/higher figures
Formula/function required: If last two
Hi everyone,I need to get transfered coloums from one excel file
to amazon's file and also compare the inventory of the original file
to the amazon file I need help since I dont know excel too good. I
will also need it to work on a macro please let me know who is
interested to help me and of cours
I've seen it written that ranges can't be used as constants.
I've got 2 different ranges that I refer to on every worksheet and in
many subs and functions. I can't figure out how to declare the ranges
and have them available in all mod, sheets, subs, etc.
Here what I have in private subs:
Dim IR
I don't think so this is possible in excel(if we don't use a VBA
code)... you can go to one cell at a time.
You can use the formula auditing toolbar to have more options.
Nishant
On Jun 23, 7:43 pm, shivashankar katageri
wrote:
> DEAR ALL,
>
> CAN ANY ONE HELP ME OF FINDING OF ALL LINKED CELLS
Before running this code, can you check if the sheet is already
protected or not. Could be that your sheet is already protected and
you are trying to re-protect it using this code.
Nishant
On Jun 23, 6:05 pm, Gert wrote:
> hi All, thought this would be easy but I get:
>
> Run-time error 100
Your question is slightly confusing.. can you post a new thread with
example...
On Jun 23, 5:18 pm, jander wrote:
> Suppose I name each of a set of columns. I can use those names in a
> formula provided the formula refers only to cells in the current row.
> But I haven't been able to figure out
HI,
Name - Harmeet
Tip - Calculate formula using F9
Detail :
Lets say you have a formula :
=IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1))
in order to calculate partial formula you need to select desired formula
like this:
=IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1))
Then press F9, it will convert the formula to va
HI,
Name - Harmeet
Tip - Calculate formula using F9
Detail :
Lets say you have a formula :
=IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1))
in order to calculate partial formula you need to select desired formula
like this:
=IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1))
Then press F9, it will convert the formula to va
Have a look at this link, the second to last message may help there is
a user form based quiz to download
questions can added to a shhet & answears are submitted by user
http://groups.google.co.uk/group/excel-macros/browse_thread/thread/3ebc6edfe952df60/c8c098b58c89024b?hl=en&lnk=gst&q=user+form#
Hi -
This link should provide you to head start on how to write macro. This
could be customized based on your needs.
http://support.microsoft.com/kb/213360
Hope this helps,
Dev
--~--~-~--~~~---~--~~
---
DEAR ALL,
CAN ANY ONE HELP ME OF FINDING OF ALL LINKED CELLS IN MAIN SHEES JUST BY
CLIKING ONE OPEN FLOWER BRACKET, it only opens first linked cell,
URGENT BASIS,
THIS WILL SAVE MY TIME
Please find the attached file
--
Thanks & Regards
Shivashankar.C.Katageri.
--~--~-~--~~---
hi All, thought this would be easy but I get:
Run-time error 1004. You cannot use this macro on a protected
sheet
Anyone knows what's going on re. my code below? Just the protecting
works but I would like to hide all formula's and then I get the error
though my sheets are not protected.
Thank you all very much. Problem solved.
Thank you very much again.
Adam
On Jun 23, 4:08 am, "Upendra Singh"
wrote:
> Hi Adam,
>
> If you are using Excel 2007, This would be a task for some keystrokes
> You need to :
> 1. Copy the data and transpose entire data in a single row.
> 2. Copy th
Suppose I name each of a set of columns. I can use those names in a
formula provided the formula refers only to cells in the current row.
But I haven't been able to figure out how to reference rows other than
current row using column names. This is probably glaringly obvious,
but I've been unable
Separating the number in A2 into digits, so that each of cells B2:G2
will contain one digit.
Solution:
Using the MID and COLUMN functions, as follows:
=MID($A2,COLUMN()-1,1)
Separating a Number Into Digits
ajaY :)
On Jun 22, 5:51 pm, mageshwaran jayaraman
wrote:
> Hi,
>
> I am Maheshwara
Other possibility is that when you have opened the workbook you select to
disable macros or the security level has disabled it automatically
Go to >> Tools >> Macro >> Secority...
2009/6/23 Dave Bonallack
> Hi,
> This just means that the code has paused for some reason (perhaps because
> yo
Hi,
Save the add in file in the excel start up location (see below) and restart
your excel and use the following formula "=ntow(Cell reference)"
C:\Users\[user]\AppData\Roaming\Microsoft\Excel\XLSTART
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-m
Hi Dear,
Please find the same mentioned below.
1274-1890-1528
*Unfeigned Regards
Manoj S Negi
"Miles & miles to go before I sleep"*
*¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·.
.·:*
*:·.
*«*:·.
.·:*
*:·.
*On Mon, Jun 22, 200
Hi Adam,
If you are using Excel 2007, This would be a task for some keystrokes
You need to :
1. Copy the data and transpose entire data in a single row.
2. Copy the entire row and paste the data in a notepad.
3. In the notepad, copy blank space between e-mail IDs.
4. Press Ctrl+H and Paste t
Hi,
Here's my contribution
If you have N/A or any other data which is commonly filled in various cells
of a work book and you would like to replace all of them with a blank or any
other character, say, Y.
1. Press Ctrl + F
2. Type the text which you wish to find
3. Click on Replace
Hi Mahesh,
It may be because the codes breaks - up in between. Try using error -
handlers OR loops to avoid this.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jun 22, 2009 at 9:55 PM, mahesh
Hey Adam,
Use this function to concatenate multiple rows.
Alt + F11 to open the VB editor
Insert\Module
Paste the code below in the edit window
Then put this formula in any cell
=CommaCon(A1:A4)
Code Starts Here
Function CommaCon(rng As Range) As String
'
' CommaCon Function
'
Dim
Hi Adam,
Do you really want 1400 email addresses all in one cell? I'm not sure if
they'll fit...
For some reason, the CONCATONATE worksheet function doesn't allow CONCAT(A1:A50)
The concatenation can be done easily in VBA, but what you want done with the
final result is another matter.
Regar
Hi,
This just means that the code has paused for some reason (perhaps because you
asked it to, or perhaps it has a mind of its own). You just need to click the
Reset button on the VBA toolbar. This will allow other code to run. Basically,
you can only run one code at a time. When a code is in
30 matches
Mail list logo
