I have an Excel workbook with 2 sheets.
Sheet1 has values from database1 in 'Row Format'.
Sheet2 has values from database2 in 'Column Format'.
Columns in Sheet1:
Emp #
Name
Basic Salary
House Rent
COLA
Columns in Sheet2:
Emp #
Name
Earning ID
Amount
Sample value for Sheet1:
1
ABC
100
200
300...
Thanks
I am using Internet Explorer 5 to check my emails from hotmail and yahoo accounts.
In the hotmail.com interface, there is an Options|Help link. I clicked Options link.
There is no setting option available for Message Forwarding. There is one for Message Replies.
In Message Replies...
My friend sent me an email on my hotmail account. I want to forward this email to someone else. I need to hide address of my friend in the forwarded message. But when I clicked forward, an attachment line appeared with a file message.txt.
In the message area; from, subject and date appeared...
Thanks TonyJollans
I copied the code in a standard module and put in E2 =MenuSelections(A2,"Menu8") and copied down.
The code gave most (not all) sequence numbers accurately when I used 'Super Menu' as a Base Menu ID.
For example, if my highest menu urn is Menu1 and I used...
Thanks TonyJollans
if there is a fixed maximum depth of, say, 3 or 4, menus then a formula is possible
There is not a fixed maximum depth, but a maximum number may be assumed as 20 for example
otherwise it will require code
I have no problems if I need to write some VBA code
will give...
Hi TonyJollans,
(a) Are there ay duplicates? In your example you get to Menu3 by selecting #2 from Menu1 followed by #5 from Menu2. Might there also be, perhaps, an option #7 from Menu1 leading to Menu3, or some other combination?
Yes, a program urn or a menu urn may be invoked from more than...
I have an Excel Sheet, in which I have downloaded menu options of an application.
This application is menu-driven. Every user is assigned a menu. Each menu has serveral menu option numbers.
A menu option number may lead to another menu or may call a program. I have dowloaded all menus of...
Thanks
In my opinion, Invite and Add are not same. When you invite members, members are required to accept the invitation through email or through yahoo group website. But when you add members, members are added to the group without any need of acceptance from members.
invite/add worked for...
Geoff,
I checked for the sample data as well and it didn't work. I must be making some mistake:
For the following file, I proceeded as follows:
1. Cell Pointer on A1:
2. Data -> Filter -> Advance Filter ...
3. Action: Filter the list in place
4. List Range: $A$1:$D$13
5. Criteria Range...
Geoff,
Message in the status bar is strange for me as the records were not filtered at all. They remained 5445 and not 5444.
What I did this time is that I selected Copy to another location in the action and entered $A$5448 in the Copy to box. This time I got the following message:
The...
In an excel sheet, I have employee's position titles and departments. I have to find unique positions in each department.
ColumnB: Position Title
ColumnC: Department
There are some more columns in this sheet in addtion to the above two.
Sample Values are:
P1 D1
P2 D2
P3 D3
P1 D4
P5 D5
P6...
I made a Yahoo Group on groups.yahoo.com website. Membership Type for the group is Restricted. I invited students to join the group.
Some students are new to Yahoo Groups so they were not able to subscribe to group. Now I planned to add them myself.
But when I clicked Members link, I found the...
I found the reason.
When I opened my mailbox, I received a message from Microsoft .NET Passport stating the reason as follows:
Verifying your e-mail address will ensure that we can respond if you contact us about a problem. In addition, some .NET Passport-participating sites may require you to...
Many thanks.
It worked perfectly.
One more question:
When I signed on to MSN Messenger with @yahoo.com address, a pop-up window appeared as:
You need to verify your email address with MSN Messenger. Click here.
Do I need to perform this step?
I added one contact in my contact list and it...
I have a Yahoo account having an email address ending with @yahoo.com. I need to use this address to signon to MSN Messenger. When I entered my email address and password, I got the message:
The sign-in name you entered does not exist.
Then I clicked the link:
Don't have a Passport?
Get one...
Many thanks Skip.
This formula is very concise as compared to the IF statement.
I also read a FAQ faq68-4725 to understand this formula.
What I learned is, this formula has worked as follows in my example (correct me if this formula doesn't work like that):
A B C
1 0 0
1 1 2000
0...
I have an Excel workbook with two sheets; Sheet1 and Sheet2.
Sheet1 has three columns:
Column A:
A1 = Total Min Income
A2 = 0
A3 = 80,001
A4 = 150,001
Column B:
B1 = Total Max Income
B2 = 80,000
B3 = 150,000
B4 = 700,000
Column C:
C1 = Tax Amt
C2 = 0
C3 = 2,000
C4 = 5,000
In Sheet2, Total...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.