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...

Thank you, I can't be;ieve how difficult I made it, thank you again

Thank you, After all my years of using Excel I have never used Advanced filter before, what a great littlre tool, it shows that we learn somthing every day. Cheers Jupops

Hi the data changes from day to day and the pivot table is not there (at the moment), I needed to create two pivot tables on the sheet, which another sheet does a lookup so all the data is on a summery sheet (which also takes data from other work sheets).

Hi Thank you for the reply that worked, but you point me in the right direction as I need to count all the unique numbers associated with 5 for example A B 12 5 12 5 17 5 12 5 16 5 12 6 12 6 Therefore the result for this would be 3 (because 12,17...

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...

Works wonderfully, thank you

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 =...

Good Afternoon AnotherHiggins When I keep running the code I keep getting the error code Type mismatch, but when I have typed in fresh data into another sheet it does exactly what you said,, so it is a problem with my data, I will try and see what it does not like. Thank you for your help...

Good Morning John This code is great (and also very instructive), but just one more quick question. can it carry to the next row automaticallt, combinding the cells until it reaches a blank row, because the Files that are sent to me often go down 1700 rows, Regards Jupops

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...

Thank you Spot on again, You are a star Jupops

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 evening Skip What can I say but it is perfect, Thank YOu Regatds Jupops

Thank you lionelhill this is great thank you.

Sorry Skip. not a good start for my question, I have follewed your link and reposted, cheers. Jupops

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...