Hi,
One way could be to use Rand or Randbetween function, but both of them will
not produce consecutive numbers. I have given a try in the attached
workbook which is using the function ROW to get +1, +2, +3 etc added, if
dragged down till the last desired number and after that a conditional
forma
Thanks Subbu,
Little correction in the last three steps:-
press up arrow and type " sum"
press Ctrl + Enter
done
Above should only be followed after you have done Subtotal for entire data
set. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.co
stcity price
oha 20
oha30
oh a sum 50
mib40
mib 80
mi b sum 120
I HAVE THE ABOVE DATA WITH GROUPS SEPERATED BY SUBTOTALS. NOW I WANT
TO SORT THE GROUPS BY THE SUBTOTAL VALUE IN DESC ORDER. for example i
i want to sort the grouped dat by sorted value in desc order. for
example the second group has to come above the first group since 120
is greater than 50. So the entire group mi b i.e the two rows and the
subtotaled row should come first and then the first group
stcity price
oh
I have a starting serial numer like 11100050 in C1 and i have a end
serial number like 11100099 in D1 i would like to get
automatically E1 to E50 those all serial numers like( 11100051 ,
11100052) .
how can i do
--~--~-~--~~~---~--~~
--
Hi Rolf,
Thanks for responding.
Please find the answers below :
1. I am getting the error which says:
"User defined type - not defined" This error is related to first
Dim statement in the code above.
Dim fso As Scripting.FileSystemObject
2. Obviously it is critical that you
If you can unlock the VBA code, then it's fairly simple
to remove an entire module and import another.
But first you have to be able to unlock the VBA.
Paul
From: Cecilia Chiderski
To: excel-macros@googlegroups.com
Sent: Thursday, October 1, 2009 12:37:25 PM
S
Hi Subbu,
Two solutions:-
1) continue using subtotal but at the end do the trick as explained in the
attachment in sheet "option 1"
2) Do pivot table
Thanks,
Dilip Kumar Pandey
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@
i am putting subtotals in exel 2007/2003 but i want to dispaly
additional columsn in the subtotals. how to do that
ex
stcity price
oha 20
oha30
oh a sum 50
mib40
mib 80
mi b sum 120
i can display a in
Thank you, yes this works great
On Sep 30, 9:13 pm, Tony Bender wrote:
> I have an Excel application and on my 'front end' I would like to
> generate a pop-up note when the user hovers over a 'shape'. (This
> would be similar to how a comment appears when the user hovers over a
> cell with
Hi, I have an Excel file with a locked VBA code. I need to create in a
separated Excel file a Macro to update a Macro stored in this first Excel. I
read some useful information in the web, but still can't write the appropriate
code to do it. Can somebody send an example??
Thanks,
CC
Hi Vinod,
Data sheet is now retrievable to Sheet 2 and for this you just have to
select the required option from the drop-down. I have done this using Excel
Functions and the same sheet is attached herewith. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan
Alternatively, but still along the lines proposed by Paul Schreiner,
you could make your code more concise by using this approach which
avoids all the activating and selecting that will slow your code down
once you apply your code to larger ranges:
Dim searchRange As Range
Set searchRange
It seems to me that you skipped over the setting of the database
itself, i.e. the Set dbs = statement is missing. Therefore your VBA
code doesn't know what dbs is.
On Oct 1, 12:05 am, kuhrty wrote:
> I am trying to create a table in Access 2003 through VBA. I keep
> getting an error 91 where th
Hi
In excel there is no DMedian function, but you can use the below code
for the same, this is an array formulae.
{=MEDIAN(IF((B1:B12=B20),C1:C12))}
Rajender Soni
--~--~-~--~~~---~--~~
-
H Kris,
What i needed was to sum a range let say D2:D11 from all xl files to
one file.
That means : i need to get value of D2 as 10 in the master sheet where
the cell D2 has 3 & 7 in two individual files.
Regards,
Kunal
On Sep 29, 7:33 pm, Kris wrote:
> Hi Kunal,
>
> See this thread. Adopt th
You need to be a little bit more specific in HOW this code is not
working for you. Obviously it is critical that you specify the range
of cells you want to copy (in the code you showed it is set to
"B28:F28". Is that correct? Also the code assumed that your daily
reports contain the date you want
Hi Sumanth,
You can use VBA to add multiple sheets once. The steps are as below:
1. Open VBA Editor (Press Alt+F11 or go to Tools->Macro->Visual Basic
Editor)
2. Click View->Immediate window.
3. Enter the below command and press enter. 15 sheets will be added to
your wor
Hi Kuhrty,
You have to set the value of dbs (database) first to continue
Let me know if this helps.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of kuhrty
Sent: Thursday, Oc
A "Class" is a way of defining a new object and attributes.
let's say you wanted to create an object called "People".
Now, for each person in "People" you wanted to save the
Name
Address
City
Postal_Code
Phone_Home
Phone_Work
Phone_Cell
Birthday
Start_Date
You would define this "Class" in a Clas
Excel does not store "dates", it stores numbers.
In the case of a date, it stores the number of
days since 1/1/1900.
TIME is the fractional part of a day.
so 6:00am is actually 1/4 of a 24 hour day,
so it stores it as .25
So, today at 6:00am (10/1/2009 6:00 AM)
to Excel is: 40087.25
You may choos
Alternatively,
Do the following,
1. Select the column where you want to apply the date format
2. Go to >Data>Text to Coulmn>Fixed Width>Click Next>Click at the end
of date (this will insert a column break)
3. Click Next>Select from Coiumn data format Date (DMY if u like)
4. C
Hi All,
Can anyone tell the difference between a Module and a Class Module. What are
the advantages in writing a code in either Module/Class Module.
Regards
Umesh Dev
--~--~-~--~~~---~--~~
---
Thank you Dilip,
My question is
1) When we want a new sheet we use Shift+F11 ,
Shift+F11 can be used to create one new sheet at a time, what would be the
command to create more than 2 or more than 2 new sheets a time ?
Thank you
Sumanth.
On Wed, Sep 30, 2009 at 9:02 PM, Dilip Pandey wrote:
>
Hi Ram,
Actually I got tht passware from my frnd. It works nicely to crack MS Office
passwords (I tried on excel files and and it gives you the alternate
password within seconds) but for now I m trying to crack password for the
pdf document which Vivek has sent me...it's running on..let's c whethe
Hi Anish,
Please provide the details of the PDF Cracker application (if possible the
link to download) so that even we can download the application.
Thanks & Regards,
Ramkrishna T. Padhi
On Wed, Sep 30, 2009 at 5:03 PM, Anish Shrivastava wrote:
> I have a Password Cracker application...may be I
Kindly send me the file I will send the password & the file
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685310
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
--~--~-~--~~~---~--~~
-
Hi Tony,
I think this is what you may need.
Right Click the Shape
Select Hyperlink
Click Screen Tip
Type in your message
Click OK
Click Bookmark
Type A1 in the top box
Click OK
Click OK
On Oct 1, 9:13 am, Tony Bender wrote:
> I have an Excel application and on my 'front end' I would like to
>
28 matches
Mail list logo
