• Export from Access to Excel shifts decimal position randomly

    I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...

    MBachman5 pointsBadges:
  • How to use Excel to manage inventory

    I'm using an Excel workbook to manage a fulfillment inventory. It contains three worksheets. Worksheet 1 includes the current inventory of all the products available for fulfillment. Worksheet 3 contains a list of the packing lists and quantity of the products (by part number) that were sent out...

    Horqua5 pointsBadges:
  • Problems with tranferring flat file from mainframe to Outlook as CSV file

    I am trying to e-mail a plain text comma delimited flat file from the mainfram to Outlook. I have the coding working to transfer the file but when the file arrives in outlook the first character on each line is an '&'. When EXCEL trys to open the file it generates an error message that this is an...

    Rickb19745 pointsBadges:
  • Excel Form Macro

    Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...

    Dinosaur995 pointsBadges:
  • Copy and paste in Excel using Visual Basic scripting?

    First of all - Thank you.... I receive info in Excel worksheet "A" with columns of variable length which I want to cut and paste into Excel worksheet "B". Worksheet "A" info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length information then...

    Bmac5 pointsBadges:
  • EXCEL find-copy-paste

    Hello! Using VBA for first time, so everything is toughed for me.. The problem is: we need to find on the first sheet named SD in second column all cells contianing word 'drilling', then for each cell copy row which contains that cell and paste it in other sheet or book (doesn't matter). Please...

    Snursmursik5 pointsBadges:
  • Microsoft Excel requires Microsoft installation CD whenever machine is restarted.

    When ever I restart my machine and I try to open an Excel document the application always requires the Microsoft Office installation CD to reconfigure Excel before the document opens.I insert the installation CD and it goes on to reconfigure itself but I have to do this every time I restart the...

    Phyl15 pointsBadges:
  • RE: copying cells over filtered rows.

    Ever since I got the new version of Excel, this happens SOMETIMES which is very dangerous. When I have filtered rows, and want to copy/drag and paste a value, sometimes it copies the value between the filtered rows!

    Aerccm35 pointsBadges:
  • processing biometric data

    can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?

    Benibo15 pointsBadges:
  • Microsoft Access export to Excel changes values

    I have a table populated through a form using lookup tables. When this table is exported using "right click,export" to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens

    Lsegura12125 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:
  • Compare values Excel vs Lotus

    I have a database with 200,000 clients in Lotus Notes with a form call Enquiries, with these values: Name, Last Name and email and so; also I have a field in excel call Clients.xls with 2,000 rows with columns Name, Last Name and Email. I need to compare the clients in Excel with the ones in Lotus....

    LotusScriptMex5 pointsBadges:
  • New to macros (probably a simple question)

    Cell c4 and c5 have check boxes. Cell E4 has a number. Cell F5 has a number. Cell E6 and F6 are blank but is where I want to total a the column. If the check box in cell C4 is checked then the check box in C5 cannot and vice versa. If the check box in C4 is checked it will add the number in E4 and...

    Glennbeach5 pointsBadges:
  • 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 Imported Data

    Import data from an AS400 using the query function in XL. Hangs. Connection is ok, finds the tables but when it tries to retrieve records an write to XL work sheet it just hangs. Can anyone help. I believe it is a job on the AS400, but which one?

    MECA15 pointsBadges:
  • Transferring files from AS/400 to Sharepoint 3

    We want to be able to transfer data files (Excel Spreadsheets) from our AS/400 to a Sharepoint site. We've been advised that e-mail is a solution, but for security reasons our company won't allow this. We have a utility that let's us create the Excel files on the AS/400 but cannot work out what's...

    Debu66er5 pointsBadges:
  • why is a blank cell returned in pivot table when data exists?

    I have a pivot table with one cell that appears blank. when I double click on the total for that row, the field is not blank. Why is the data not displaying in the pivot table? Show all is selected in that field header.

    MightyTightYouth5 pointsBadges:
  • Automation of SQL Report

    Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??

    Ramesh63635 pointsBadges:
  • Adding dayys to a date without adding weekends

    I want to enter a date into a cell in microsoft excel and in another cell I want it to add five days onto the previous date without includind the weekends in so if I enter the 7/16/2008 into the first cell then I want to have it add five work days making it the 7/23/2008 instead of five regular...

    Hoganstech10 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