• coloring rows “if” true

    I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...

    Tstychalski5 pointsBadges:
  • Excel 2003: Novice user wants to set up database for research

    Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?

    Hocosteo5 pointsBadges:
  • How to send a mail to multiple recipients from Microsoft Excel sheet?

    I have an excel sheet. This excel sheet has data for many recipients. every row has an email address (lotus/outlook) and then the next four cell in the same row has the data for the same recipient. I want a macro to be created so that when I run this macro a new mail is drafted for each recipient...

    Micqa5 pointsBadges:
  • Appending Excel to SharePoint list

    I am trying to create master database in SharePoint such that excel can be appended at the end of it. End result is to get dynamic reports / dashboards and email notifications from SharePoint. Please guide how this can be done.

    Navin88810 pointsBadges:
  • Import lotus notes view data from Excel

    I need to import frequently data from some Lotus Notes views into my Excel sheets, I want to know if they are a macro or a VB script which could do that.

    Witold200830 pointsBadges:
  • Data transfer from webpage to excel

    I have a complicated problem for data extract from a web site. It is about a horse race analysis. Problem description as below I want to retrieve some historical data and non-dynamic Datas are spread into many different web pages and they are in asp. Pull down menu is on the web page and have to...

    Hbongsui5 pointsBadges:
  • Microsoft Excel subtraction using VBA

    I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...

    Devisri20 pointsBadges:
  • Change date format

    I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this decade is...

    DanBubis75 pointsBadges:
  • Cell Colors in Excel

    I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.

    TweetyBird695 pointsBadges:
  • Creating a list in one Excel cell by referencing several other cells

    Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...

    Adventuredev55 pointsBadges:
  • Year over year pivot table

    Similar to your example except I want to show monthly columns with two separate years as rows in the pivot table below each customer, then insert an additional row between each customer for the % change like this                 Jan     Feb     Mar Smith & Co 2013        ...

    TonyX105 pointsBadges:
  • Can’t open IFS doc

    I have an excell spread sheet on the IFS, I have a drive mapped. I can see the spreadsheet (it's small). When I click on it to open it will sit there saying it's downloading but then I get the error "Can't Open File". It has worked in the past this just started happening. Thanks

    Johnd0155 pointsBadges:
  • Cell color coding

    I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I cant see the formula used...

    Mas85 pointsBadges:
  • How to use databases made in Access or Excel in SQL

    How can I use databases made in Access or Excel in SQL? I'm trying to import readymade databases in SQL.

    Dragan1525 pointsBadges:
  • Convert PDF to Excel

    How to convert PDF to Excel?

    LDS5 pointsBadges:
  • Import from Excel to Oracle 9i

    How can I import data from Excel to Oracle 9i?

    Binty25 pointsBadges:
  • Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • excel macro formated to highlight current date

    I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same "number" "=DAY(TODAY())" in every month.

    Jlcford15 pointsBadges:
  • Data Conversion

    How to convert PDF files to Excel Files

    Aumarve5 pointsBadges:
  • how to increase no of rows of validation list (drop down list)???

    Hello, Thanks for viewing this thread. I have one excel sheet. I have entered following data in 30 rows in one column and created the validation list for that data 10:00 AM 10:01 AM 10:02 AM '' '' ' '' 5:00 PM I want to show drop down list box with my own no of rows to be displayed not current...

    Abhikop5 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