• 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 2003 – Conditional Formtting Help

    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:
  • 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:
  • How to send a mail to multiple recipients from Microsoft Excel sheet?

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

    Micqa5 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:
  • How to link a macro by clicking on a cell of an Excel sheet

    I need to get the current time by clicking on the cell in excel.

    78345 pointsBadges:
  • office 2003 excel filter

    Within excel 2003 I have 1245 records in a sheet and I try to add an auto filter and not all items in that column are in the list, why. When I select just a few cells in the column and apply the auto filter the missing items are there but highlighting the whole sheet or just the entire column and...

    Mhill10 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:
  • Excel question

    I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don't want to send an entire spreadsheet. Can this be...

    Alexworley5 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:
  • Conditional Formatting – Excel 2003

    Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and "eguals the company in...

    Lhunter5 pointsBadges:
  • Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.

    Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.

    Bpbp5 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