Thanks a lot
Mrs. Jayshree Shah
On Sat, Jul 25, 2009 at 8:07 PM, Upendra Singh wrote:
> Use Index-Match
>
>
>
> =INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1))
>
>
>
> Regards,
>
>
>
> Upendra Singh
>
> +91-9910227325, +91-9310760597
>
>
>
>
> ---
Hi Jiant Can you please send the sample file.
Regards,
Andy
On Sun, Jul 26, 2009 at 6:01 AM, giant wrote:
>
> hello i am new to this group,and i would like help with command
> buttons.I will have cells (A1:A10 and B1:B10) randomly selecting names
> what i want is to put a button in c1:c10 to co
I use the import external data function in the data toolbar. It
works
great in any interval I want. Does anyone know how to import new
refreshed data into an adjacent column on a worksheet so the latest
refreshed data can be then compared to the previous data. I would
like to refresh data once
hello i am new to this group,and i would like help with command
buttons.I will have cells (A1:A10 and B1:B10) randomly selecting names
what i want is to put a button in c1:c10 to command each cell ei(one
button in c1 to refresh the names in a1 and b1 and the same for
a2,b2:a10,b10 so a button will
Dear All,
As i forget all my password of our excel file 07.
now i am immediate need of editing to my excel sheet.
Please assist how could i unprotect my workbook.
As i could not attach all files.
Please help the needy.
Rgds,
Abdul Hakim
--~--~-~--~~~---~--~~
It is possible and I have done it provided you have some fixed or
logical rules to follow.
Regards,
On Jul 24, 11:26 am, ERAMike wrote:
> I don't think this can be done but I'm going to ask anyway. I would
> like to know if there is a way to automate the Text Import Wizard.
> The situation I h
You can create a list for Parent Items.
Afterwards whenever you need to add data, you need to go to the last row of
you data (where excel is showing * and Highlighted row after that).
All the formulas applied to entire column till that row will be
automatically copied to next row.
Regards,
Upe
Dear Dilip
Can you please assist how did u crack the password protected file
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 8:44 PM, Dilip Pandey wrote:
> Hi Abdul,
>
> Attached xls has been "Unprotected"
Hi Russ,
If it is possible and do not have any data sharing issue, then please
share the spreadsheet with the group. Alternatively, you can provide
the dummy scenario(s) as well.
We all are here to learn and explore the vast features and
capabilities of Excel, and these type of practical problem
hi Abdul...
You can copy paste the sheet date to some other sheet in some another
workbook
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 6:17 PM, Abdul Hakim Khan
wrote:
> Dear All,
> Please help me qu
Hi
For the benefit of the Group, can you attach a sample file containing
the dummy scenario. Thanks
DILipandey
On 7/25/09, Telenochek wrote:
>
> Hello everyone,
>
> I have a worksheet that calculates system performance on Sheet1 based
> on electronic components, whose data is located in other
Excuse me Ravi,,!!
Just missed one step in the key combinations. Here I go once again.
click anywhere in the data, ctrl+*, pop-up key (next to right ctrl
key), alt+s, v, m,
enter).
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@y
Hi Dave
Please find the pdf file at
http://groups.google.com/group/excel-macros/files?&sort=date
Save the first listed file in the link above
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 5:24 PM, Da
Hi
The query is not very clear can u please explain what you want
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 5:43 PM, big smile wrote:
> Respected friends,
>
> I am new this group.
>
> Attached p
Hi Debashis,
I think this problem is somewhat related to the differences between
featurs of Excel 2003 & Excel 2007. If you are considering the file,
which I have attached then I do not see any "grouping" problem in
that.
Dear "Group", Can anyone research on this, who has the Excel 2007
install
encounter this error : can't find project or library
when try to run a code which contains Calendar1.Value
any help?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1.
the file can be opened only through a TORRENT application such as
bitlord.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 4:52 PM, DEBASHIS BANERJEE
wrote:
> if Save target is clicked .. file is
Good Work Mr. Dhananjay,
Just a little concern, your solution seems to be like struggling when
we have "First Name", "Middle Name" and "Last Name". Would you like
to take a look, at the attached file in which I have given a dummy
example. I think the "dynamics" is missing here. But once agian..
Hello Mr. Anil Panchal,
This is the better solution on your query.
Thanks & Regards,
Dhananjay
On 7/24/09, anil panchal wrote:
>
>
>
> Hi All Frnd & Sr.
>
> Please find attached file. there is a Full Name Like Anil Kumar Panchal I
> want saprate anil kumar panchal in 3 Columns with the help of
Dear Friend ,
whats happening while I open this file , the work sheet is not
opened forwithly.
i am to go to exl option , there it is required to activate
calculation option as automatic..
then it runs..
another file is there whose file name has been changed as file name
.[gro
Hi,
Take a look at the following link->
http://www.oaltd.co.uk/Excel/Default.htm
Download the file ModelessForm.zip
This one demonstrates how to make the userform modeless (thereby allowing
the user to select cells on the worksheet) and make the user-form understand
current selected cell(s). O
Mr. Williams,
I'd suggest you to extract the URLs to the next column and delete the
original column.. In order to achieve this, use following formula.
=MID(A1,1,FIND(".com",A1)+3)
It assumes that you have the list in Column A.
Thanks,
DILipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Hi
Keep Smiling..!!
Your problem is solved and attached with this email.
Thanks,
DILipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 7/25/09, big smile wrote:
> Respected friends,
>
> I am new this g
Use Index-Match
=INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1))
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Th
Right click on sheet tab and select Ungroup.
You've grouped your sheets...
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who unde
Hi Debashish,
Not sure about Excel 2007, but below is what I have tried on Excel
2003 and it is working great.
'Enter following in workbook code area:-
Private Sub workbook_open()
Call CalcStatus
End Sub
'Enter following in any module (say module 1) code area:-
Sub CalcStatus()
Cells(1, 1).Select
Hello Roman,
Please provide sample file with the data & the desired output.
Thanks.
Dhananjay
On 7/24/09, Roman wrote:
>
>
> I need a formula that picks up what filter condition is used on a
> column of values.
>
> For example:
>
>
>
> Column A Colu
Hello,
This is the solution (attachment files) as per the query I understood.
(Pl. append data in 'Main.xlsx' & the same will reflect in 'dupli.xlsx'.)
If not happened please mail me back. I will show you the another way.
Thanks & regards,
Dhananjay Pinjan
(Mob. No. 9922255533)
On 7/24/09, TA
I have a huge ss and need to work with all of it. There are certain
cells in each long row that I'd like to see at all times.
I have a "viewer" connected to a hot keyed macro that does just that.
The form also allows editing of those cells.
Is is possible that the form can be made to follow me w
Wow...!
Thanks Danial for positive reply. That's what I am searching for.
Thanks so much.
But one more query, why need to press 'Ctrl+Shift+Enter'?
What will happened if I will not press that key-combination?
What an array formula?
Please assist me, Master. I am waiting for your r
Respected friends,
I am new this group.
Attached please find the excel 2007 query file-
I would like to know the shortcut formula or macro to get the result.
Thanks in advance.
--~--~-~--~~~---~--~~
---
Hi Anil,
Please find the solution attached. I have done this using nested
function of Excel and given out two different approaches.
Thanks,
Dilipandey
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 7/24/09
There is a file in the files section, Excel_2007_Macros_Made_Easy.zip,
that when opened has an rar extension that I can't open.
Can someone open this and save it in the files section as a pdf file?
Thanks
--~--~-~--~~~---~--~~
if Save target is clicked .. file is down loaded.. but the downloaded
file becomes such a format that can not be opened .
what should I do ?
On 7/22/09, vivek agrawal wrote:
>
> Hi Ankur,
>
>
> Right click on the link and click "Save Target/Link as". This would
> download the torrent
Dear Freinds .
i am using exl. 2007 . in exl option formula tab - formula
option can never be automatic..
every time it becomes manual
is there any way to make it automatic.
kindly help >
Thanks and regards
Debashis
--~--~-~--~~~---~--~
Hi RAVI,
This can be done by multiplying data with one. Steps wuld be-> type 1
anywhere & copy it. Select the data range, go to edit-> paste special
-> select values, select multiplication & ENTER.
After copying one, the correct key combination to achieve rest of the
process wuld be ( click anywhe
Hi Ravi...
I am not easy with pivots but guess the following link might be helpful
http://www.brainbell.com/tutorials/Excel_VBA/Size_Of_A_Finished_Pivot_Table.html
Hope it Helps
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25
hi manoj
this would remove all the zeros from inbetween...
he wants to remove only the trailing zeros...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 4:14 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.co
hi ravi,
just do as follows its very simple and esy...
1. Ctrl F
2. find 0 and replace with blank
3. hit enter.
Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
On Sat, Jul 25, 2009 at 2:56 PM, Ravi Megharaj wrote:
> Hi Friends,
>
> Can someone provide me for
many many thanks Ayush ji. . my problem is solved .
On 7/25/09, Ayush Jain wrote:
>
>
> Hello all,
>
> The issue of Debasis banerjee is resolved. The auto calculation
> setting was disabled which is now enabled.
>
> Best regards,
> Ayush Jain
>
> On Jul 25, 2:29 pm, "Daniel" wrote:
> > Try o
Hi Ravi
Select the cells containg the data and then run the code below
==
Sub RemoveZeros()
Dim vRows As Range
Dim vCells As Range
Dim vPosition As Integer
Dim vChar As String
Set vRows = Selection
For Each vCells In vRows
Position = 1
vChar = Mid(vCells.Value, Posit
Hi Kunal
I dont have the specified book. See if could search in on internet...
torrents might be available
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Jul 25, 2009 at 3:37 PM, kunal wrote:
>
> Hi, Vivek,
>
> Do you ha
Hi Aamir,
The problem with your spreadsheet is Borrower name in Main sheet is not
matching with Account name in Source name.
e.g. In Main sheet Borrower name is "NEW ALLIED ELECTRONI" but in Source sheet
it is "NEW ALLIED ELECTRO". Means the text is not matching. If you can make it
same you c
Hi, Vivek,
Do you have the following ebook:
Create Dynamic Charts In Microsoft Office Excel 2007 In Beyond (2009)
Regards,
Kunal
On Jul 23, 11:20 pm, "Aamir Shahzad" wrote:
> Thanks Vivek. I downloaded.
>
> Regards,
>
> Aamir Shahzad
>
> - Original Message -
> From: vivek agrawa
Hi,
Can someone share vba code to remove the Cache memory, when we run the pivot
tables. Whenever i run the pivot tables the file size expands substantially.
Thanks
Ravi Megharaj
--~--~-~--~~~---~--~~
---
Hi Friends,
Can someone provide me formula or code to remove leading zeros from a set of
data. Eg:
00J123
K232
0P22
The resultant data must look like:
J123
K232
P22
Thanks in advance.
Regards,
Ravi S Megharaj
--~--~-~--~~~---~--~~
---
Hello all,
The issue of Debasis banerjee is resolved. The auto calculation
setting was disabled which is now enabled.
Best regards,
Ayush Jain
On Jul 25, 2:29 pm, "Daniel" wrote:
> Try opening it with Open Office.
>
> Daniel
>
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegr
Sorry; replace ";" with ","
=HYPERLINK(LEFT(A1,FIND(".com",A1)+3))
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of Daniel
> Sent: samedi 25 juillet 2009 10:43
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Ma
Oups.
Replace ";" with "," :
=OFFSET(INDIRECT(A1),1,0)
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of Daniel
> Sent: samedi 25 juillet 2009 10:52
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Re: H
Try opening it with Open Office.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of DEBASHIS BANERJEE
Sent: samedi 25 juillet 2009 09:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel Problem - kindly help
Dear Friends,
Dear Amir,
You can use folloing formulat to pul the data to main sheet from source sheet.
VLOOKUP(C12,Source!$C$2:$J$14,8,FALSE)
I used Account No. for look up you can modify it by chaning C12 as u required.
Hope this will help you.
Regards,
Shafique 0333-5154498
Fro
Could you attaché the excel file.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Telenochek
Sent: 25 July 2009 0
You can use replace all and in find area put ".com*" (without quotes) and in
replace area put ".com".
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-m
Dear Friends,
I have a problem ..
I have an XLS file . file size is 1 MB .
it has 10 sheets and includes numourous formule.
I had been working well till yesterday.
today when I open the file , the file name as indicated on the top of
the sheet has been shown a "groupe"
Yet another way would be to use Event Class, store the reference to the new
Image Control in the event class object and that takes care of the Click()
Event of the Image object.
Regards
Ajit
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On
Hello.
To obtain Amplifiers!E2 :
=OFFSET(INDIRECT(A1);1;0)
Amplifiers!E3 :
=OFFSET(INDIRECT(A1);2;0)
Etc.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of Telenochek
> Sent: vendredi 24 juillet 2009 21:52
> To: MS EXC
For a URL in A1, use :
=HYPERLINK(LEFT(A1;FIND(".com";A1)+3))
HTH
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of mkabwilliams
> Sent: samedi 25 juillet 2009 05:27
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Mac
57 matches
Mail list logo
