moves

Hi, I think this might be easy or just not possible. I am creating a training matrix for my company to drive competence and have started an excel document. The progress charts show progress and will help set targets. The problem I have is when I insert a new row, adjust size etc, all my...

The code below works with renaming workbooks, however it also moves them as well. Is there a way to modify the code to make a copy of the workbook instead of moving it? Thanks much in advance! Sub RenameTesting() Dim OldName1, NewName1 'Work books based on cell values below OldName1 =...

Hello All; I'm using; =IFERROR(HLOOKUP(B$32,$19:$30,11,FALSE),"") The problem is the lookup ID of Row 11. Row 11 is looking at the name of Sam. If this name, Sam, moves, the H-Lookup no longer works. I've cured this problem using VBA to make it more dynamic, as Sam moves, Sam is still...

This is possibly more of a maths question than an Excel question, but I thought it was the sort of thing that someone on here may be able to answer... Say that I have a data extract from one system, and I need to change the order of the columns so that they eventually end up in the same order...

I am new to Excel VB and have managed to get my code to work, but it seems I could simplify it and also complete the next part of the project as part of the simplification. The part I have working is dragging the formulas in columns T through Y down to the next blank row on the sheets that need...

Hi I need a sumifs formula that has a dynamic sum range (it moves based on a criteria). Cheers

Good Afternoon, Minor issue with this IF AND Formula, I cannot get the results section to be more dynamic. As I copy the code down the page it stays Sheet4!B2/BFR!B2, but I need it to move to B3, etc. How would I go about that? The rest of the formula moves down correctly, just not the if...

(Apologies, just joined - this question has been asked here before, but was not followed through) I have received a locked spreadsheet (from a source I wouldn't be able to query) that wraps both horizontally and vertically, when moving between cells using the arrow key. e.g. if the active...

hi have some code in my spreadsheet, that formats a certain area whenever i enter data into any area within. However although it works, it selects and moves the cursor away from the area I am working at . Anyone have a solution? KR Trevor

Hi, There is probably an easy way to do this but I can't seem to figure this one out. How do I construct a formula to reference a cell, like "B10" so that the value returned in "B10". I want to the formula to change when the cell moves, for example if I add a column and "B10" moves to "C10...