Recent content by Jediantman

Someone's macro has invaded my Excel and disabled all my right click functionality. The macro is from a trusted source and it was intended only to prevent users from negotiating the sheet in any way other than they intended, using various buttons and functions. Somehow though, this constraint...

Works perfect, thanks!!!

Just wondered if there was anyway to use a variable 'search' within an IF so that I can avoid overloading a nested IF. I want to search for the characters 'S5' in a particular cell, but those characters can appear in around 7 or 8 codes that will occupy the cell, so I guess I'm looking for a...

All the worksheets get copied from each of the individual workbooks. There are differing amounts of data, hence the differing ranges specified, however they all follow an identical . In the example above Aidan's file is simply the first one so his data gets pasted into A23, the next person's...

Hi there, I'm currently updating the first macro I ever wrote, as every quarter it evolves into a slightly bigger operation. The previous two incarnations have worked without a problem but now I get the 'Compile Error: Procedure too large' message appear. Frustrating doesn't begin to describe...

Thanks Narayan, the OR(ISBLANK) is just left over from the original person who created the spreadsheet and so I've never fully understood it's use, I just have left it there to save messing around further. I appreciate your comment but the main issue I have is around the need for me to check the...

Hi everyone, So I'm facing a dilemma. I use a spreadsheet to work out publication dates for reports and it's all nice and easy because it flows very nicely from one cell to the next and works without a problem. That is until holiday periods need to be calculated. Previously I have gotten...

Thanks for your help guys. I'm going to have a little play with your suggestions and see if it will work. I can't really provide the sample files as the data I'm dealing with is confidential and I haven't the time to remove the data based on the amount I'm dealing with.

So I'm getting very frustrated with a macro I created which basically opens 14 individual sheets copies a selected range of data then pastes it to another. All was fine and working without problems until I had to include some hidden columns into the source data, which are also replicated in the...

I've actually managed to sort it now, thanks, by changing to a vlookup and using another IF to qualify it all. Thanks for the offer, I just needed to to step back to separate the wood from the trees!!

Hi all, I have a bit of a problem with a spreadsheet that I use to control the timeline of the life of certain reports. The original spreadsheet we use was created by an outside consultant, who no longer works with us, and so it has been adapted as things have changed however the construct and...

I have a bit of a nightmare with an IF function that will need to calculate based on the value of one cell. All very simple so far, except that there are 56 potential values for that cell so I can't use a nested if to just perform what I want. I've tried to combine it with a lookup to make it...

Thanks, I'll give it a go and let you know.

This is my first fully fledged macro that I'm creating and so I'm still very much a novice. Thanks to some help through this message board I've created my code for compiling 10 individual workbooks into one 'Master', by copying and pasting the data to specific locations in the master. All...

So thanks to this website I've managed to create my macro to consolidate all my spreadsheets, thank you!! The only slightly annoying issue left is when it prompts me to answer the questions: "Do you want to save the changes you made to 'Spreadsheet.xlsx' and "There is a large amount of...