Good Afternoon
Experts:
I have a Workbook with 3 sheets. This workbook is used to track changes made to a system. The first sheet contains a column called "Type". This type is either a ...
Hey all,
I need help with building an Excel Macro. I am using Excel 2003. The Excel Sheet is used for keeping track of Inventory, and Column A contains values for the Unique Item Number. T...
What is the Excel formula to SUBTRACT a percentage from a gross amount to result in a net amount?
Example:
Gross Price = $106.00
Sales Tax = 6%
What was the original net price before tax?
...
Dear Sir,
Am using Microsoft Office SR-1 Professional on Microsoft XP Pro.
Am unable to open any excel file by double click. I have to first open excel and then open the file.
I t was w...
I need to connect an excel spreadsheet to a website that requires login credentials. I have seen a few threads that discuss these but were unable to follow. Could provide how I would go about...
Intro:
I have an MS Access database backend from which I am attempting to pull information into an MS Excel-based user form. The form is complete except for a table which I want to populate ...
We would like to automate an Excel 2007 worksheet by assigning a cell (or multiple cells) to easily insert a date (using a built in calendar). When the cell is clicked - a small calendar icon...
Excel automatically puts a '-' negative sign in front of negative numbers.
But what if I want to put a '+' plus sign in front of positive numbers ?
I can do this with the formula ='+ '& ...
Hi!
I have a problem with special function 'PasteValues' are assigned to my regular paste functionality in Excel. It all works perfect as long as I stay in the same workbook but if I copy a v...
Hi,
Using Excel VBA, how do I create a cell value that concatenates a cell with a text format (ex. Cell A1 = "Text"), another cell with a number format (ex. Cell A2 = 14)and puts the combin...
Experts,
In the attached workbook (EE-FROM_DATABASE-03-2008_NB.xls) I have a data import from a database on worksheet (DATA). What I want to do is create some code in VBA to copy most cells...
Hi Experts,
I've got a worksheet where some columns have text entries that are not displaying all of their content. All of the cells are formatted as Wrap Text but none of them are Merged. ...
Experts, I would like to create a list in a UserForm using Excel VBA that fulfills the following requirements:
a) allow multiple selections,
b) only allow items contained within existing l...
Hi Everyone-
I have gotten help on step 1 of the process below. I need help with steps 2, 3, and 4 which are excel based. Attached is the code I have been given so far. I am stuck with g...
I am trying to remove a broken VBA project reference using VBA so that I can add the currently available reference. The broken reference is in the VBProject.References collection but when I us...
This is driving me nuts! I can't seem to find an answer anywhere yet it seems so simple.. anyway:
I have a web page saved as a .htm file, that actually has a big table in it. I want to load...
Here's the issue, I have invoices in excel that are saved with the invoice #. I want to create a single workbook (bookkeeping.xls) that gathers information from all the invoices like name,ch...
Once I click on a cell in Excel it's as if I have a button pressed. I cannot do anything else within Excel. F8 does not fix this. Scroll lock is not on. The "EXT" and "SCRL" are not present. I...
I have a worksheet where I need to firstly autofit the column widths of the data (excluding the first row which is a header) but limit the maximum width of the auto fit to 25. Then in specifie...
I am using the End xldown command to activate a range. I first search for text in a cell, the header, and then offset down one row to get to the first cell in the range I want to activate. M...
I have a user who has been working in an Excel 2007 file. It has data in it. Then one time when he trys op open the file it opens to a blank background screen, no cells and just the menu bar a...
I have 2 columns of numbers say column A and column B.
I want column c to be = (column A X one of the cells in column B). How can I do this?
Thanks.
Hoping someone can help me with the following Excel error message:
'Excel found unreadable content in '<excel file>'. Do you want to recover the contents of this workbook? If you trust the ...
Hi,
Excel file too large takes long time to open,save etc.Can all the macros be saved some where and i should be able to run them when required.
Can i have all macros in some folder.When r...
I have a macro that creates a separate workbook for each of my accounts. Each account can have up to 10 different sets of contact details. Each workbook contains buttons that allow the user to...
