I have a client that wants to somehow change a letter into a number with a macro or VBA. The source is an excel spreadsheet. His example states that for instance U=2, qd=3, qod=3, I=1, IU=5 w...
I am trying to use a For LOOP to alternate throught the range of cells in Excell but do not quite remember the syntex. Here is what i am trying to do:
On row 1 select first three cells ...
I have two spreadsheets that I need to compare and merge. Here's what I'm looking to do:
Sheet 1
Customer Number Customer Name Accounting ID
12345 Joe...
Hello expert
I need a expert in excel who can help me with plotting the tasks in the project
say
project tasks, Planned Start Date, Planned end date, Actual start date, Actual end date
i...
Hello Experts:
Looking for a VBA script that will find the maximum value for a range of values in one column and repeat this between breaks. The breaks are not uniform meaning that there m...
Currently, when the file is already opened and another user on the network open it, it says it is already open by User1 would you like to open in read-only?
What we want with this particular ...
Hello,
We have an internal web application based on PHP and MySQL that produces HTML tables of data. The data is generated by MySQL queries in the PHP code, and the PHP write the files as ...
How do you make a Class module created in an addin visable and usable to other workbooks?
Addin properly loaded and registered. Office/Addins/Addin checked
within vba project... Tools/Refere...
I am on excel 2007, XP:, and working with financial statements in Cordobas (foreign currency); I need to convert all of the in balance sheet, income statemtns, cash flows, et al financial numb...
Hi Excel guru
I need some help in vlookup, I tried and it did not work, I have spreadsheet with 2 tabls sheet1 and delta and I need to lookup from sheet1 using the first column in both tabs...
folks
i have column A "Projects" in sheet 1
in sheet 2 i have two colums ie column A "Projects" and column B "costs"
how do i add/summarize all the costs of each project into sheet1
...
I was wondering if anyone has ever accomplished creating a dynamic dropdown in Excel that derives it data from Access 2007. I am to make a cell a dropdown and have it populate that data with a...
HI Experts,
Is it possible to change the colour of one cell and display a word based on the colour of a different cell?Basically the other cell is already conditionally formatted to go red if...
Hello,
I have a formula in a cell " =SUM(F5*1.5)+E5 "
What I would like to do is; if the answer is " 0 ", then I do not want the cell to show anything. Leave the cell blank.
If the cell hav...
I have read about shared workbooks being unreliable in previous versions of Excel with reports of file corruption and data loss.
Is the shared workbook function safe enough to rely on in Ex...
Excel won't format currencies with a Yen symbol (¥). It only formats with the prefix JPY for Japan. How can I make it format a currency with the ¥ sign?
With reference the the post at expert-exchange
http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_22853654.html
I found that the conditional formating shud be a go...
I have an Excel spreadsheet that in certain cells i want to accept only certain types of data.
for example
If we want a date in the field only a date can be entered not n/a or anything else.
My macro knowledge is very basic, so apologies if this is extremely simple.....
I can get Irial's solution for "Excel Macro to higlight entire row on a condition" to work perfectly on its own...
In a 2003 excel workbook1 i have a button to which i have assigned a hyperlink to another workbook2. Workbook2 needs to be scrolled through by the user. In workbook2 i want to show a butto...
I have an Excel spreadsheet with about 15 columns and want to print them out onto a 8-1/2 by 11 inch page.
I want to do this because printing a regular spreadsheet of about 15 columns would...
Seeking a software solution for the following:
I work at a school where, currently, proposed events, fixtures, sports matchs, drama performances, etc are put onto an excel spreadsheet. Whe...
I have a spreadsheet with 20,000 rows formatted like this:
ID Description
000873 Breach of Implied Warranty
Negligence,Strict Liability
Unfair an...
