Pulling down data online on a daily basis in excel format to check for new records, using Excel 2003 Professional. I'd like to have a way to extract new records from this workbook and output ...
I want to multiply each value in a cell by 10.
I am using a macro to format the cell range like so:
With Range ("A3:A1000")
.numberfortmat = "#.#"
end with
I tried :
With Ra...
I have pulled the top team in each division. Now I need to pull the name of the next highest ranked team in the conference that hasn't already been listed as the top team in the division. So...
I have a file containing time information, but in the wrong format for excel. ie. ie 'general format 7.01' as opposed to time format 7:01. I want to do time calculations but if I just conver...
In the attached file is a macro named CopyValues, the macro does what it is supposed to do which is move data from columns F & G to Columns C & D but after I run it, it removes the formulas I ...
I use Windows XP. Is there a way to easily see the various labels one has assigned to each worksheet in a workbook without hitting the tabs at the bottom? Some of my workbooks contain many w...
A1 = "Reboot - Investigation (1) Run program (1)
I want
A1= Reboot Investigation
B1= 1
C1= Run Program
D1= 1
The first 9 rows of data in the attached file are the output from a crosstab (qyr_crosstab worksheet). I want to Transpose the data into the Template Worksheet as shown.
Thanks.
I need a formula for excel.
I have three numbers, 500 (Cell D3), 30 (Cell D4) and 49 (Cell D5). I would like each number, D3, D4 and D5 to give me an alert when it reaches 20.
For example:
...
How would I go about creating a list in column A of weekdays between January 2004 and December 2010 skipping weekends.
EX
1/1/2004
1/2/2004
1/5/2004
.
.
.
12/31/2010
i have a vb macro macro that creates a chart in excel. it has the primary axis but i need to add the secondary axis with the same scale as the first axis. I have attached the VB macro and an i...
Hi EE,
Please refer to attached file. On cell S32 I´m getting #VALUE! I wonder why. I´ve checked this and can´t find the reason for that.
Thank you.
Hi
I'm putting a forecasting template together (please see the attached template). The user enters the period and the colour of the cell changes to represent the closed period. For exampl...
Hello all,
I would like to hide some rows. However, I would like to hide every fourth row if a button is clicked. For example:
A
1 Name 1
2 Forename 1
3 ...
I am trying to create a template folder of template workbooks that then dump their information into a summary workbook. The template folder will be copied and pasted into several project fold...
Hello All,
Trying to build a formula to interpret cell a4. If cell="CLR", then "None", else if the words 'BKN" or "OVC" appear then take the first three digits before the words, if neither ...
Hi,
The enclosed worksheet has just 1 simple procedure in Module 1 that builds a word document and replaces 1 word from HA to HO. The problem with this is that I have to click the dialog bo...
Hi All
Im using Excel 2007. After Ive applied a filter I want to run a macro to only affect the visible rows. Any ideas on how I can do this?
Thanks in advance
Elmo
Hello,
I have a complicated set of calculations in an Excel spreadsheet - but basically I put in one number at the top, then I get one number out at the bottom. (In case you're interested, th...
What I would like to achieve is if a cell equals blank then it will equal "Please select" on the Conditional format.
Would anyone be able to help me.
Kind regards
Gazl
Hi experts,
The following macro creates a backup of a file by saving it, then zipping it and moving it into a folder. When the workbook is open this macro is automatically called on by ano...
Hello Experts,
I am trying to compare dates (see below for reference) in Excel 2007. I need to issue a new license every 5 years based on the expiration date however; the date of issue depen...
I have attached a sample spreadsheet of equipment. I would like to insert a line before each category with text. I have manual created what I want to see on the display example I have attached.
The title should say it all. Anyone please? It is annoying that the document scrollbar is tiny and can scroll all the way to the bottom even though the document really only contains about 300 ...
Hi
I am trying to develop a reporting tool, whereby the user enters a period and the month and YTD figure appears. I'm thinking of using offset, but was wondering if there was a better way...
