Here is the scenario.
On Sheet1 I've got a list of 1000 names in column A. In Column B I've got their dietary restrictions, one of the options is "vegetarian".
On Sheet2 how do I genera...
For sake of simplicity let's say my original formula states =A1; however, data in A1 contains values past the standard two decimal places needed. Therefore, I want to conduct a find and repla...
see attached workbook...
Hi Experts
Need to remove the array part of the formula from the worksheet "CashFlow Yearly" the rest of the formula remains.....
I have firstname column and lastname
i have about 50 record or or rows
I what to merge name field together
example
FNAME | LNAME | FULLNAME
sam Johnson
Tony ...
I want to protect one sheet automatic before the book is saving.
so I add one button to the sheet and the VBA code is :
Private Sub CommandButton1_Click()
ThisWorkbook.Save
End Sub
...
How do I edit Custom Toolbar for Custom Add-In after moving from Excel 2003 to Excel 2007? We have a few macros that we no longer need and we deleted them from one of our Excel Master time sh...
The attached code works great without question:
It chunks up excel using each CustomerID in the table. Curently uses supplies the "Begin and End date"
and the code sort data by group then c...
hI
I have a link on my Web Page which opens a excel worksheet used to input data which is imported to my SQL server via another web page.
I was wondering is it possible to carry information...
see attached workbook.
Hi Experts
Need to find a solution, having a slight problem when the user follows the following sequence:
1. Goto Main worksheet "Deal Selection"
2. Grey Add...
I have a cell with a week Number, 30, 31, 32....in COL (BN)
I want to sum in (BX15) only the totals in COL (BW) that have the same week number in COL (BN)
thanks in advance
Attached is Ron de Bruin's example workbook on how to email from within Excel by using Outlook calls.
My question is this:
On the "SendRow" worksheet, how can that specific macro (or fun...
I have an analysis map which I would like to run a macro if I manually change the fill color
wj
I have a shape named Houston, I control the color of the shape by changing a cell's color and then clicking on a button to run the sub below. Would also like to have a check box next to the b...
Hello Experts,
I am using the following formula: {=IF('STEP 3 ALL OTHER STAFFING'!$C$12:$C$55='STAFFING SUMMARY'!A9,'STEP 3 ALL OTHER STAFFING'!X8:$X$55," ")}
But not getting any values t...
"The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:
External data ranges (also called query tables)
i h...
One last question on this spreadsheet.
I want to automate the cells in Col R like I did with the ones in Col's O and P.
Col R takes a total of the beginning of the year until the last mo...
I need to copy a single worksheet from one work book to another. I'm using the line of code:
Sheets(sWsName).Copy Before:=Workbooks(sNewWbName).Sheets(1)
Is there some way keep Excel fr...
Can you please tell me why the following formulas do not calculate correctly in Excel? I'm starting to loose my mind. Google calculator doesn't work right either, the windows scientific calc...
Hi,
This is a general question to start. I have multiple pivot tables and need to know the best method/s for programatically setting them up for a default output when a report is run from ...
Hi,
I have 1 large pivot table and need to use this table including its cache to base the other tables on. I have got as far as the code below which is not far off, but I am getting a subs...
Hi,
have been stressing over combining charts trying to get the answer but to no avail.
I have 4 sets of data, a1, a2, b1,b2. I need to have a column for 'a' values and a parallel column...
I am trying to develop an employee time record keeping system. Is there any way in excel for an employee to click a cell and have it automatically input the exact time when they do this? So ...
Hi got a client who keeps on sending an excel sheet that contains over 40,000 rows of data unfortunately they keep on adding data which contains rows which I do not need.
The data that need...
I've pasted a long column of information into Excel 2007. It looks like this:
A
B
C
D
E
F
G
H
I
K
J
L
I want to transpose the data so that instead it looks like this:
ABCD
...
I'm trying to update a spreadsheet that contains room numbers but no matter what I do excel insists on converting the room numbers to dates. So a cell with "8-20" in it becomes "Aug-20" as so...
