Hi Harish,
There can be a macro written based on your requirements using
Worksheet_Change event. But there is no inbuilt feature to accomplish
the same. For drop-down you can use Data --> Validation feature of MS
Excel.
-
Regards
Ashish Jain
http://ww
Thanks ruchi
--- On Fri, 6/5/09, god is gr8 i love u wrote:
> From: god is gr8 i love u
> Subject: $$Excel-Macros$$ tip for the day
> To: excel-macros@googlegroups.com
> Date: Friday, June 5, 2009, 10:55 PM
> Hi Everyt one
>
> I am Ruchi
>
> Tip 4 the
> competition
>
> F11 is a short
Hi Alokeshwar,
This is absolutely normal.
1. When you try to fetch the values from userform1, it is initialized
and new value of Test set upon. To avoid this you can use activate
event of userform1. Difference between activate and initialize is of
Foreground visibility active state and Backgroun
Hi George,
Try this macro!
Sub Macro1()
Dim myDep As Range
Dim CWbk As Workbook
For Each myDep In Range("F1:F30").Cells
Workbooks.Add
Set CWbk = ActiveWorkbook
ThisWorkbook.Sheets("as is").Range("A1:A3").EntireRow.Copy
CWbk.Sheets(1).Range("A1")
'CWbk.SaveAs T
Hi Ryan,
Did you tried templates on Microsoft website? Here is the link, plz
reply with your feedback.
http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZXL
Here you'll find templates on
Receipts
Invoices
Budget
Inventories
and Expense reports etc.
Hi Yu,
Thanks.
I guess we could use the Range thingy to do the same thing.
This allows us to input the Column using its alphabetic notation.
The following 2 lines do the same thing, finding the next cell in Column AA
B = Cells(Rows.Count, 27).End(xlUp).Offset(1, 0).Address
B = Range("AA" & Rows.
Hi Alokeswar,
Thanks for sharing that.
Regards - Dave.
Date: Sat, 6 Jun 2009 02:55:50 -0700
From: alokeshwar.tiw...@yahoo.com
Subject: $$Excel-Macros$$ Re: remove module - password is password
To: excel-macros@googlegroups.com
I apologize, please use following password:
password
Regards,
hi ryan,
u sound to know debit and credit well , u can do the spreadsheet your self ,
please try
cheers
On Sat, Jun 6, 2009 at 9:51 AM, spazlon wrote:
>
> Hello,
>
> I am looking for a personal finance spreadsheet. I tried making one of
> my own, but quickly realized I lacked the knowledge to d
To select blank cells in a range:
Select the range, then hit Cntl + G > Alt + S (special) > k (blanks) > hit
enter.
Srinivasan Ethirajalu.
On Sat, Jun 6, 2009 at 1:13 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi all,
>
>
> Name : Manoj S Negi
> Subject : Insert a new sheet in
Hello Everyone,
Thanks for your overwhelming response on this initiative. I request
you to post your tip in the thread and the post started by Group
Owner. It will be very difficult to keep track of tips posted under
different subject topics.
The title of the thread where you should post your ti
Dear group members,
My need is to parse Excel file.
I have names of departments in F column:
aa
ab
ac
df
(et cetera, 30 departments)
I have list of departments and other information in my source Excel
file.
My task is:
1) copy three first lines of sheet "as is"
2) copy all strings with "aa" in
Hi Dave,
Thanks for your share.
This is one of lines I used a lot as well. The only drawback of this is
that you need to give it the number of Column. Most of times, it is more
easier to give the Column Name,like "A" instead of 1 when it reaches beyond
"AA" 'cos you need to count the numbe
Hi all,
Name : Manoj S Negi
Subject : Insert a new sheet in the excel workbook
Tip :Use *Shift+F11* to insert a new sheet
in the excel workbook just hit Shift with F11 and you will see a new sheet
in the excel workbook.
*Unfeigned Regards
Manoj S Negi
"Miles & miles to go before I sleep"*
*
Hello,
I am looking for a personal finance spreadsheet. I tried making one of
my own, but quickly realized I lacked the knowledge to do what I
wanted. Basically I want to have one sheet that will have all of my
transactions on it with a Debit and Credit column. I will also have a
sheet for each o
To select blank cells in a range:
Select the range, then hit *Cntl + G* > *Alt + S* (special) >* k* (blanks) >
hit *enter*.
Srinivasan Ethirajalu.
On Fri, Jun 5, 2009 at 8:53 PM, ayush jain wrote:
> Hello Everyone,
>
> We are launching a weekly "BEST EXCEL TIP AWARD" from today onwards in the
Hello Everyone.
Its a great initiative by the Owner / Moderator of this group
My name is* Satish P N*
3 excel shortcut tips which u will find useful
1. Shift + F11 will insert new worksheet
2. Ctrl + 9 will hide selected rows, (to display hidden rows Ctrl+Shift+9)
3. Ctrl + 0 will hide s
I apologize, please use following password:
password
Regards,
Alokeshwar
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things
Hi Group,
Tip.
The following line of code line returns the first blank cell at the end of a
series of data, ignoring any blank cells within that series.
In this case, the series is in Col A.
I use it a lot when copying stuff onto the bottom of existing data.
This is not new, but might be useful
Hi Alokeswar,
Your attachment has the VBA protected with a password.
Regards - Dave.
Date: Fri, 5 Jun 2009 18:37:58 -0700
From: alokeshwar.tiw...@yahoo.com
Subject: $$Excel-Macros$$ Re: remove module
To: excel-macros@googlegroups.com
You can use SendKeys to protect and unprotect VBA project. S
19 matches
Mail list logo
