We have a spreadsheet as follows:
CustomerID CustomName ManagerId ManagerName
1234 Mike 100 Mike
1234 Mike 200 James
...
Hello All. This code is not working. It returns an error "cannot be used on multiple selections". I thought it was working but after further testing I realized that it was copy information ...
I have 2 pivot tables connected to same data
On one when I click the + sign to the left it just opens the detail for that item
On the other it opens detail for that particular item (the ...
I want to repopulate my Table in a spreadsheet when I run the macro. I want to keep the first data row and the header(for various reasons) thus I want to Delete the table rows beginning at cel...
I am trying to creat a pivot table base on data in CLP Development Cost.xls tab CLP. THe table starts in cell A9, but Excel is selecting A1, so when it goes to creat the table, I get an error...
see attached file
Hi Experts
Need to amend the current macro in module 1. To profrom the following step.
1. Find title's in column C (i.e. like point 3. Structuring) in grey shaded box ...
In Excel 2003, on a Chart sheet, you could Format shapes/text boxes and such to specifically not be printed.
This tickbox has vanished in Excel 2007 and I can't find any way of not printing o...
In XL 2003, I sort my column, and then run the subtotal function. It seems to work, and it gives me a total cell after each change in the column I ask for, however, I see the function's there ...
Hi All
I have an excel spreadsheet that has the following Cells
% Complete, Start date, End date
0 08/08/08 08/20/08
0 08/01/08 08/25/08
I want to ...
Hi, one of our clients has a Windows 2003 Terminal Server running Office 2007. When opening any excel spreadsheet (2003 xls, 2007xlsx) it will default to say Sheet1, if you then click on any o...
I have data in cell A2 and B2 which I want to concatenate into cell C2 for example.
A2 B2 C2
Valerie Davis Valerie Davis
But aft...
I have a excel main workbook containing 50 tables. I would like to have a seaparate xls file for each table in that workbook. So at the end I will have a folder containing 50 diferent xls fi...
I am using this formula
=IF(ISERR(PERCENTILE(F4:F2884,0.98)),"",PERCENTILE(F4:F2884,0.98))
and it works like it is designed to work. My task is to ignore any value in the column F4:F2884 tha...
Hi there,
I have an old HP Unix MPE-iX based machine that spits out excel and word docs to a shared folder. When the compatibility pack (or Office 2003 SP3) was installed on machines with O...
Ok, I have a problem where a user running Excel 2007 on a Vista machine is not receiving changes to an excel file that is located in a file on one of our servers. The file is an accounting fil...
I am developing a large financial model and want to provide a component of it to a colleague to review. The model is about 12MB and includes 22 components each consisting of three sheets that...
Hi everyone
I am struggling with the above,
What i need to do is create a addin for excel with printing commands on it, but as you will know, thwe printers on excel Ne number changes on ...
I have a process on my Template worksheet that when a user creates a new employee, they input into a form the employee name and department. The process creates a new employee worksheet from t...
I have received a list from a client which has the full address entered into only one cell in excel, ie: "John Smith 1981 Smith Street Green Bay, WI 54308."
I am having difficulty splitting ...
Is there a way to conditional format a textbox control . For example the textbox presents in red characters on the 'incorrect condition'; and in blue on the correct condition? The code below ...
I have a set of data and fields in an active spreadsheet
VendorName | Year | Class | Field1 | Field2 | Field3
VendorA 2003 A DataA1 DataA2 DataA3
VendorB ...
Hi,
Need some additions in the excel mail send.
The below code is done by Rob and Chris.
So need an addition to this.When mail sent it removes the "X" after the send of mail .I even need ...
Hello Experts,
Need to insert the following formula into the attached code, but am unsure how to handle looking up values on a different sheet. Formula is:
=IF(comm_date < Assumptions!$A...
I've got a file with 30-40 sheets which do weekly tracking of data, in the form
Week1 week2 week3
Item1 x x x
Item2 ...
I have the following code and functions from Kevin a few years ago. I would like to change it a little and having a little trouble.
I want to only include values in the Uniques range ( in ...
