Search results for query: *

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...

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...

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...

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 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...

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...

There is a database of Job Descriptions in Excel. Job descriptions for each job code are written in a Word File. Headings for each part of job description are copied in an Excel column using Paste Special -> Paste Link -> Text. Purpose of this link is to automatically update the Excel file...

I typed a document in an Urdu Text Editor. This Editor (Inpage Urdu) has an Export Page option that saves the document as a .gif file. Problem is that the editor makes one gif file per page. I have a file with 11 pages. I created a new document and made its height as 297*11=3267. But I got the...

In an Excel File, there are two sheets; Sheet1 and Sheet2. Sheet1 has two Columns: Column A = JobCode Column B = Description JobCode is a named range and refers to =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1) Description is a named range and refers to...

There are two sheets in an Excel Workbook; Sheet1 and Sheet2. Sheet1, Column A: A1 = Job Titles A2 = MGR A3 = ACT A4 = PROG Sheet1, Column B: B1 = Description B2 = Manager B3 = Accountant B4 = Programmer JobTitles is a named range and it refers to...

I used Named Ranges for Data Validation in Excel as follows: (To do this, I took the help from thread thread68-608325. To explain my issue, I am using same sample values). Sheet1: Column A Master Apple Orange Banana Lemon Kiwi Peach Pear Plum Column B Apple Detail SelectionBasedOnApple...

I have an Excel File with two sheets. Sheet2 has two columns. Column A = Position Category Column B = Position Title Each Position Category contains some position titles. Some Position Categories have no position titles initially. In sheet1: Column A A1 = Position Category A2 = C1 A3 = C2 A4...

In an Excel Sheet, first column is Serial Number. This excel file is shared and used by all team members to enter goals for the coming month. I used =ROW()-1 in cell A2 and pasted this formula up to A500. Now when I deleted Serial No. 5 (Row 6), then all serial numbers adjusted accordingly...

In an Excel Sheet, first column is Serial Number. This excel file is shared and used by all team members to enter goals for the coming month. I added one for column A Cell A1 = Serial Number A2 = 1 A3 = A2 + 1 I copied A3 and pasted till A500 Now each member uses this sheet and enters his...

In the SQL Server Enterprise Manager, two databases are defined in Console Root-> Microsoft SQL Servers -> SQL Server Group -> ServerName -> Databases. Names of Databases are ABCLIVE and ABCTEST. In ABCTEST, tables are defined and data is present in these tables. In ABCLIVE only database is...

In an Excel File, I clicked the save button. In the Save As dialog box, I clicked Tools->General options. I typed a password in Password to open text box. Now I have forgotten this password and badly need to open this workbook. I searched for Excel File Crackers on the net, but in all...

I have a data in an Excel Sheet with employee number and their date of joining. I want to find those employees who have completed 'whole years' as of Dec 31, 2002. Example: (Employee Number, Date Of Joining (dd/mm/yyyy)) (1,1/1/1999) (2,3/1/1999) (3,1/1/2000) (4,3/1/2000) (5,1/1/2001) Result...

In a form in Visual Basic 6.0, I used Menu Editor and defined Menus. I used ampersand (&) in menu captions. When I run the form, underscore does not appear in any option. As soon as I press Alt key, underscore appears in all options but it does not appear right away as the form is shown to user.

I am working with my colleague on a project. Both of us were given some reports to devleop on Crystal Report. I have Crystal Report version 8, installed on my PC whereas my colleague has version 9 installed. I did not take this factor into consideration and develop my reports on version 8. My...