Microsoft Excel

Print one row on all pages in Excel

Hi, Does anyone know of a way to print one row on all pages in Excel, kind of like a header? Thanks, Dustin

What is the Excel VBScript for the following...

Avatar I put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc

Linking Information in two seperate Workbooks

I need to create a Workbook that has certain cells accessible for people to enter in thier information and then have the ability to pick from a drop down list that will autopopulate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens...

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

How to Create "Are you sure you want to ...." MsgBox

I am creating a userform at the bottom of which there are various commands including "Save". When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an "Are you sure you want to save" box with the options Yes and...

Excel custom format, weekday & date line break query....

I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is nessacery for this data to be...

Export or Import data Excle to Excel (VBA coding)

Hi Experts Pls How to possible Export or Import data Excle to Excel (VBA coding) Ananda Debnath

Excel file problem in Lotus Notes

When the user is trying to open an attachment ms excel 2003 file, the user is not able to open it, but the user is able to open the file after it is saved to the computer/ The user is having problem only witht he excel files.Can anyone please help me with this?

Cell Formatting Protection

How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows,...

how to assign a numerical value to a word in excel

I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I can write the simple equation in the cost column to...

Excel 2003 toolbar functions greyed out, but not Excel 2007

I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). Could Office...

PDF save as TXT file (VBA)

HI EXPERTS PLEASE SOLVE IT I WANT TO SAVE AS TXT FILE FROM PDF FILE THROUGH VBA (XLS) CODING; I WANT TO GET THE DATAs AS TEXT MODE FROM A SPECIFIC PDF FILE IN EXCEL SHEET PLEASE ANSWER IT ANANDA DEBNATH DELHI, INDIA

VB Active Cell problem

I am a vb problem. On an excel sheet, I am trying to have a macro run when the user selects a changing column's active cell. For columns F to I on Sheet!Data, if you choose any cell in range (F9:I65000), then take the value of Column B in the selected row and make as my "Dept" Value. Can...

Loading image into MySQL database from Excel file

I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

Data transfer from EXCEL using AS400 add-in to AS400 physical file

If EXCEL is the starting point, how can I make the user specify the file name to transfer the EXCEL info to. Or how can I lock a predetermined file until after the transfer is complete? Thanks in advance

UNC alternative

I have many excel worksheets that link to other worksheets. Some link by drive letter mappings and others have a UNC name. Is there a way to link without using the UNC name? Concern is what to do if the linked server is changed. Do we have to go through each spreadsheet and change the link? Or...

How to export data from AS/400 in Excel

Hi everyone, I would like to know how to in a step by step process export date from AS/400 iseries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory...

Paste from Microsoft Excel cells to Microsoft Access table successfully but...

When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

Problems using VLOOKUP

I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a...

How do I write this Microsoft Excel macro?

Hi, I'm trying to create a macro that will move rows in my spread sheet. I am working with orders that are keyed into excel, once the orders ship or are canceled; the rows are highlighted green or red. I want these shipped/canceled (green/red) rows to cut from the first page and paste into...