Search results for query: *

Good Evening all, Could you please help, I am trying to setup a macro in excel that will save-as (using a cell's data for its title)This works as required but it saves to the default folder. I need to save it in another location, either by typing the path into the coding or preferably having...

Good Afternoon Could you please help? I have tried using a macro (see code below) I recorded to compile a Pivot Table, but the second time I ran I got the error meaaage “Runtime error ‘1004’ AddFields method of Pivot Table failed,, and when I ran debug it highlights...

Good morning all, can any one help? This is most likely a simple question, I have two columns of data in a excel; spread sheet and I want to count how many times different numbers appeared in column 1 when the criteria is met in column 2. the results will then be displayed in another worksheet...

Good Afternoon Could anybody please help. I am trying to write a macro that will concatenate cells or move the row up to the next column of a cell which starts with a number, Then stops when the two rows are empty but ignores if it is only one empty row. But then moves down the row until...

Good Evening All Can you please help? Basically I am trying to Trim cells in multiple columns is excel. I can do a single column at a time with (which is restricted to Row 3000 – to save time): Sub Trim() Dim i As Long For i = 1 To Range("B3000").End(xlUp).Row Range("B" & i).Value =...

Hi, can anybody help. I need a little help to concatenate cells until you reach a blank row. For example: 1A = TO 1B = DA 1C = Y 1D = IS 2A = MO 2B = ND 2C = DA 2D = Y so when the macro is run the cells would read TODAY IS MONDAY I have used the concatenate formula and autofilled down...

Good Evening Can anybody help? I am trying to write a quick macro that will see a first word in column A (Selection) which if met will delete that row and next 3 rows beneath it. Then carry on looking down the spreadsheet to repeat if necessary The code I have tried and failed with is: Sub...

Good Morning Could anybody please help. I am trying to write a macro that will concatenate cells or move the row up to the next column of a cell which starts with a number, Then stops when the row is empty. But then moves down the row until the cell starts with a number and repeats the...

Good Morning Could anybody please help. I am trying to write a macro that will concatenate cells or move the row up to the next column of a cell which starts with a number, Then stops when the row is empty. But then moves down the row until the cell starts with a number and repeats the...

Good Afternoon Could you plesae help. I have a max formula, which will look at a worksheet to give me the maxium time if 2 criteras are met. If you look look at the fomula result in Function Argument, the correct result is shown, but the result in the cell is showing a different answer. I...

Good Evening Can anybody help. I am trying to write an Array formula that if a number is true will display a cells result in a cell, so an example is: My data the Array will be looking at is on Details tab : zone 1 zone 2 zone 3 zone 4 zone 5 zone 6 zone 7 zone 8 zone 9 zone 10 135 138 43...

Good Morning All Can anybody help? I am trying to write a Macro that will create a pivot table that will count up and total various columns.(which will have the same headings, but the data will always be different). I have recoded a Macro and than tried to write it manually, but they keep...

Good Evening All, can you help I am trying to write a sumproduct formula that will print out a result if criteria is met. .I have three worksheets that are named Sunday, Monday and Data. The Sunday worksheets looks like 0 SUNDAY 11 0 SUNDAY 12 38992 SUNDAY 13 0...

Good Morning all Can anybody please help? I am trying to create a spreadsheet that will print a cell when two other cells are set to true. So the first condition is – if 41 is in column B, the next condition is “A” is on the same row on Column D, then print out the cells detail on the same...

Good Morning all Can anybody help? I am trying to create a formula that will print a different answer when a certain criteria is met.. In this case, if the number in a cell falls between two numbers it will show an answer. I used the formula...

Good Morning All I created a formula a long time ago, which now I need to amend. This is where I am finding a bit of a problem. the fomula =SUMPRODUCT((LEFT(spool.xls!E1:E22000,1)="E")*(spool.xls!H1:H22000>0)) would count up all the cells in column E which started with c, thath were above...

Hi can anybody help. I am trying to write a formula that will add up a total in column B if the criteria is met in Column A, in this case if it falls between two sets of numbers (1 to 10), the formula I tried (but failed) is =IF((A1:A10>0)*( A1:A10<10),"sumproduct+B1:B10",0) an example is...

Hi Guys Can anybody advise me, I have two different formulas that I use in two separate cells, can I merge the two formulas into one larger formula? The two formulas are: =IF(B2>1,B2,A1) - this will copy cells down with the previous cells contents if the cells are blank and =RIGHT(A1,11)...

Good evening all I am still having troublr with OR fuctions, what I am trying to do is when a criteia is true then it will copy the cell or place in a zero. I am using the two formulas =IF(MID(C1,4,1)="/",C1,0) and =IF(MID(C1,4,1)="-",C1,0) bothe formuldas work seperately but I cant merge...

Good Aftertnoon Cany anybody help me?What I am trying to do is if two arguments are correct then set an option to true. The problem I have 10 of these arguments that need be checked so for example Col A Col B TRUE 1 0 TRUE 5 2 FALSE 45 4 TRUE 35 3 TRUE 12 1 TRUE This represents: If Col A...