Hello,
The code below is from ( http://www.experts-exchange.com/Q_23808238.html ).
I would like it if the output that is put to Sheet2 would be kept all in one column. Instead of having t...
i have this line in a macro i recorded
ActiveSheet.Range("$CBO$1:$CBO$31").RemoveDuplicates Columns:=1, Header:= xlYes
and the macro always works on this range, when trying to reuse it.
...
Is is possible to freeze the panes from the column A to H and anything onwards would collaspe into this range if say you scrolled to Column AE.
The only thing being the range would be H9 to...
Hi. My question is can I move a validation list off of the worksheet where the validation occurs to another worksheet and reference it from there? Excel doesn't seem very accommodating when...
I have uploaded my worksheet You will notice if I try and put a "H" for example in the cells G9:CO23 I get an error message. I am aware that the worksheet is locked (password "gary") but not t...
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...
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 ...
Developing macro to select a range from A1 through the "lastcell". Usually I record new macro and edit the results. However, recording twice yielded an absolute and a relative reference to the...
Hi, I wrote the formulas below to retrieve the characters after the "-" sign in Cell U1. It returns the same result. What is the difference between FIND and SEARCH. Is one better/faster tha...
Hi
i have an simple table with scores that i wish to chart as data points along the x axis.
please view below bar chart.
i would like to not show the full bar just the data point end.
Can ...
Hello all,
I have an exciting quesion regards rows:
I have a sheet which has a lot of summary info from rows 1 to 9.
I then have four pieces of information repeated from cell ten onwa...
I have a need for a basic formula
Pls see attached spreadsheet for details. I have two teams... whichever one is selected in C2:C7 should get the associated points (B2:B7). The cumulati...
I have an Excel Userform with 2 seperate frames with option controls in them. Unlike Access you can reference the group as a whole and get the value from it. Hoe do you, without writing a lo...
I have multiple Pivottables which refresh when and close and open my excel but I need to refresh them on some button click or save.
How do I achieve this?
Hi everyone. I wrote a code that loops through 8500 rows step-1 and deletes the entirerow based on 4 criterias. The problem I'm haivng is, it freezes excel for about 2 mins with screen updatin...
I have a spreed sheet named clients with columns A to P, in column E I have a list of users alias such as
E
User1
User2
User3
I think I could use vlookup but not sure how.
...
I have a series of worksheets that have charts positioned on them.
Is there a way I can define the height, width and position of these charts exactly?
The idea is to have them all line u...
I am creating a graph comparing dates on specific jobs. However, the issue that I am running into is that sometimes I can have 10 jobs and other times I can have 200 or more jobs. The issue ...
I've got the following equation in over 1000 cells in a column:
=F34*('Data'!D72*1000/'Data'!D38)
I need to find a way to change this formula in all 1000+ cells to:
=F34*(INDIRECT("'D...
I have a cell that shows system time using Now(). Let's say Sheet1!B2.
I have a different cell in a different worksheet (Sheet2!B11) that gets updated by the above cell with the value. For ex...
Hello, I am trying to write a macro for excel where i place the cursor under the cell showing a dollar amount and have it grab the value from the cell above and do three short formulas to cal...
I have a spreadsheet (attached) which I want to do the following:
Update Date Record Created - whenever column C is updated, it writes the current date into column A (and the date mustn't u...
I have a long list of names which I need to do a select query . But I need to add commas to the end of each name. How can I do that?
I need a field that will put the current date into a field, then from that point on reflect the date that the sheet opened in. I have a excel template that users open, and should immediately ...
Attached is the code that I have so far.
I also attached a workbook with two spreadsheets - what the report is now and what it should look like after the changes.
I need to modify the code...
