• Linking a checkbox to another checkbox – Excel 2003

    In Excel 2003, I have a spreadsheet with multiple sheets (including a detailed page and summary page). Each sheet has about 20 subjects that contain YES / NO / N/A answer checkboxes. I need to be able to link corresponding summary and detailed checkbox's with each other. EXP: When you check the...

    Meman22435 pointsBadges:
  • Excel 2003 – conditional formatting

    Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date Column C = Due Date -...

    Kelz82740 pointsBadges:
  • Sparklines in Word or Excel

    Has anyone ever used sparklines in Word or Excel (both Office 2003 versions? What tool(s) did you use? What did you find best to use to summarize large numbers of data points (>25,000)? Thanks for the assistance.

    Labnuke9932,960 pointsBadges:
  • Ms Excel Question

    i have entered different students name in column A, Paper name in Column B & their marks in column C. like: john english 90 magi maths 15 john stats 99 john history 35 & i've applied this formula: =if(A2:A66000="John",sum(C2:C66000)) to get the total marks of John in all papers,but it doesnt work....

    Moonzy5 pointsBadges:
  • Can I link items between Outlook, Word, Excel, and Access, through the Calender view?

    Can links be set in Outlook Calender '07 to docs in Word, Excel, Access? I want to be able to go to a set date and access from that view all items pertinent without having to go looking for each item separately. Is possible?

    Notumbo15 pointsBadges:
  • Outlook export

    How can I export email messages to excel or a file?

    MarshaLehan5 pointsBadges:
  • Automatically populate a form based on a match from another worksheet.

    Ok, here goes... I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a 'Talent Profile' form (also created in Excel) that I give to HR whenever...

    Jedski2520 pointsBadges:
  • How to update data using Microsoft Excel VBA?

    I HAVE A CELL "A1=NUMERIC VALUE" & "A2=NAME OF PARTY" WHICH IS UPDATED EVERY MONTH AND I WANT TO SAVE IT WITH "DATA" SHEET WITH EACH PARTY NAME(CELL A2) AND ITS MONTHWISE VALUE(CELL A2).HOW CREATE DATA SHEET WITH MONTHLY COLOUM NAME I.E : DATA SHEET: NAME OF PARTY APRIL08 MAY08 SURENDRA KUMAR...

    Sa2915340 pointsBadges:
  • While generating Excel thru BO

    While Generating Excel thru BO. Sometimes it will partial results

    Satishsurana5 pointsBadges:
  • SSIS and Microsoft Excel

    I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...

    Cathryn35 pointsBadges:
  • Excel 2007 charts

    I have a macro that runs when a cell is updated by a PLC. When this cell changes its value I insert a cell into a column and copy data from another cell and paste it into that new inserted cell. My problem is that my chart that is associated with the data where the cell is inserted dissapears. I...

    JimGlover5 pointsBadges:
  • Using Excel, I past from a table brom a web site and excel puts everything in one cell

    Using Excel 2003, I paste from a table on a web site and excel puts everything in one cell. I have had no problem until today. It seems excel is not recognizing the seporators as it did before. I am using CTR-C and CTR-V to bring the data into my spreadsheet.

    Canthandle5 pointsBadges:
  • Conditional Formatting Excel 2003

    I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and "IF" statement on columns 2 and 3. Stating if column 2 is after or 1 month from today's date highlight in RED. And column 3 should state if column 3 is less than 3...

    Reyes335 pointsBadges:
  • HELP WITH JOINING 5 TABLES

    I need to join 5 tables and the probelm is that I have imported 5 seperate excel spreadsheets and the first column in all the spreadsheets is the same and I need to combine all that data to see if there are any duplications throughout the 5 spreadsheets and then combine some data that may be the...

    Law1235 pointsBadges:
  • How to track who amended a particular file

    Hi, Is it possible to have a way to trace who updated a particular file (word or excel etc) in windows 2003 ? Can auditing AD objects solve this ? Thanks and regards, Leo

    Purin20 pointsBadges:
  • How do I populate an SQL table created on the fly in RPGLE?

    I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

    SteveFletcher80 pointsBadges:
  • Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

    hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue. when...

    Sagar20005 pointsBadges:
  • Macro to select a range in Microsoft Excel and paste in Lotus Notes

    HI ALL, I have created and Macro which sends a mail to many in that i need to upgrade as mentioned below Recipients Email Address STUDENT # GRADE COUNTRY 123@dd.com 000123 1ST GRADE United Kingdom 321@dd.com 000321 2D GRADE United Kingdom 213@dd.com 000213 3RD GRADE United Kingdom For each mail id...

    Balu07835 pointsBadges:
  • Predefine a named range for an exported SQL Server Reporting Services report

    How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following