I have an Excel page that uses VB to sort data into 3 columns & however many pages long. I'm controling the page lengths in the code, but I know this will change depending on the printer used,...
Hi Experts,
Please advise how to go about this:
I have the following fields for each row in excel (i have placed figures as example):
B jan. 6 material requirement 10...
Hi,
I would like to produce a chart similar to the one in the attachment. I am comparing Current grades of students with their target grades and what to show their progress across their su...
Hello Experts. How can I use the following "NumCop" variable to loop thru the printout code to print the number of times. I would like it to loop so the pages are properly collated.
Any i...
I have a client that was using Microsoft Outlook to email a single worksheet from an Excel workbook. Our exchange server has been acting up lately so I directed her to use Outlook Web Access w...
I am currently working on an Excel VBA project. I am taking a user's input via textbox and passing it into a string. The user's input consists of numbers like, "2259879.00001". This number ...
Hello,
I have a basic line chart in Excel which graphs percentages on the Y axis. I'd like to highlight the 0% value on the Y axis by having this axis line bolded. Is this possible?
I'd ...
Hi,
I have a pivot table linked to an Access query (Excel 2007, Access 2003). I added a new field to the Access query and am trying to replace an old field with the newly added one in a cop...
1. See my coding below:
2. I have 'Define Name' of the range -
=OFFSET(Sheet1!$B$8,,,COUNTA(Sheet1!$B:$B)-1,7)
2. I have create a button and assigned the code (see below)
3. The but...
I use the attached macro to add a sub total.
It adds all rows of cells from 1 left and 1 row up of the active cell up to an "x" in the same column.
However it doesn't always work.
I can't w...
Is there code that will run an autoexec type of code that will check the day of the week of the current date and if it = Friday, then create a copy of a specific WkSheet within a Workbook and ...
The below code is what i am trying to use to move a folder that a user selects in a listbox. It keeps giving me permission dened which does not make sense since, i can move it in windows.
...
I would like to congratulate Saurabh, aka saurabh726, for his lightning fast ascension to double genius status. He's always on the question before me, and his answers are even good. Remarkable...
I am trying to add a column in Excel of a time duration.
I want to add to arrive at total hours, minutes, seconds.
I have tried to manipluate formats, but still can not get it to work.
I am...
IT Admin has set security to high for excel macros ,and as a result users are unable to create or run macros ,is there a way to create or run macros even the GP has set excel macro security to...
I have an excel sheet with two columns. Name and Price. Now some rows will have the same value for Name but the price for everything is different.
I want to take and group all distinct ...
Hi,
So I have some excel data that I need to plot on several worksheets, and they all are of the same format.
I made a macro to graph the data on the first worksheet, but when I click on...
Hi,
2 Workbooks 2 sheets if match found in colum Q comparing Colum A color Red the cell.
Workbook1 sheet name where there is Data to compare in colum Q is "Desktops"
The other sheet name ...
My problem is that the following code
ActiveCell.Value = Format(DateAdd("m", 1, ActiveCell), "mmm-yy") defaults to the current year.
I would like the year to correspond to whatever is in th...
Need a formulae which can return zero when the count of variables do not match.
Since there is a mismatch between frequency of variable B in column A and E, I want the formulae to return 0 ...
I am using this spread sheet to drag information from another sheet.
On the other sheet it looks like this
A B C D E
1 School T hunder Roa...
We have an excel worksheet with macros that hasn't been used in at least a year. The excel spreadsheet was created by an employee that is gone. When we go into the spreadsheet we can run the...
I'm creating a formula for each cell in a list; I use the .FormulaR1C1 = ... to insert it. It has worked fine up till now, but for no reason it started malfunctioning - I used to have
"=IF(...
I am trying to make a UserForm in Excel 2003 that will show details of a job. The Jobs are supposed to be chosen through a two-step process; first the user selects the employee, then they sel...
Hi All
PKHari helped me with the original question that I asked. The question is located at http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_237741...
