can anyone recommend a source of VBA for Excel examples (MS Office 2003)?
Add-Ins.com has a downloaded list of 1000 macros but this is $29 but this may be poor when I actually get to view it
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...
I'm trying to modify a pivot table created by someone.
I can not find the source data in the worksheet or other related area in the folder. If I can find the source data table, then I ca mana...
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
...
MS Excel (all versions) has two characteristics that have me fed-up; so I'm hoping someone with broad spreadsheet experience can make some recommendations. The two problems:
1) MS Excel can ...
hi, i'm sorry i thought i understood this question, but i don't.
i'm trying to calculate Stdev as following:
Application.WorksheetFunction.StDev(Cells(i, 5), Cells(i - 50, 5))
vba is...
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...
Hello,
I was wondering if it was possible to cross reference a spreadsheet that I have with all of my services tags
with another ones that has computer name, service tags order date invo...
I create a worksheet in Excel 2003, I go to Tools>Protection>Protect Worksheet. I add a password and protect the sheet. When I exit Excel and go back in to view the worksheet it comes right ...
Sender sends an excel spread sheet to my gmail address. I opt to print as google spread sheet. The gridlines appear on the spreadsheet but are not highlighted or bold. I take Adobe print opti...
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...
We have a spreadsheet that uses macros to copy formulas and formatting on instruction by the user. The spreadsheet has about 150 columns (Globals.MaxCol) and the following code is executed. In...
I'm looking for a countif formula that will allow me to count the number of occurences where Bruce, Raj, Mark, Eric or Stacey have a value in the adjacent column of Open
Open Bruce
Open Ra...
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...
I am looking to use this code to help sort my spreadsheet. It's exactly what I'm looking for except for one small piece. I also have some pictures inserted into my cells that I need to follow ...
I have built a spreadsheet that obtains data from many other spreadsheets using lookup functions. The linked files are contained in a folder named F08 (for the fiscal year.) Now as F09 is up...
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...
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?
I am working on a workbook with two worksheets at present (One with cost prices and the second with formulas).
I am using vlookup from the second sheet to to find the part and price on sheet ...
How do I calculate compound interest in Microsoft Excel? Two questions:
If ¬100 is invested for four years after which the amount in the account has increased to ¬330, what is the compound ...
Column G
SUB LOCATION 1 Hi Folks
I have put this function into G20
INTAKE ...
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 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.
