a15

Hi, I am wanting a code that will copy any cells within the Range of A10 to A30 that have any data in them, to another worksheet, but ignore any cells that are blank and not copy the blank cells over. I have managed to get cells to copy when i push the macro button but what I want to happen...

Hello everyone. I have been searching through the forums looking for an example to delete the contents of a cell based upon the value in another but cannot seem to get it to work. What I have is a spreadsheet that in A15 if it is blank, I would like to have E15 to delete it's contents. If A15 is...

Hello, I would like to have option to return cells with value/text in other sheet to another. So if I have value in range for example from A2 to a15 in sheet1, I would like to return all values/texts without gaps to range a2 to a15 to diffrent sheet. The best option it would be makro but i...

Hello Everyone Can someone help me convert below data from: <colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody> JR TR1 TR2 TR3 TR4 TR5 TR6 TR7 TR8 TR9 TR10 TR11 TR12 TR13 TR14 TR15 TR16 TR17 TR18 1 a1 a2 a3 a4 a5...

Hi I want to be able to highlight a cell below another cell. For example, if I highlight A2 in the table below, I want A15 to be highlighted also, regardless of the value contained in it. How to do this? Thanks Jimbo <colgroup><col style="width:51pt" span="5" width="69">...

Hi, I have a vlookup that extracts two names from one cell on another tracker =VLOOKUP(B4,'[Project Tracker.xlsx]MAIN'!$1:$1048576,114,FALSE) This gives the correct result of; John Smith & Joe Bloggs I need to separate both these names into two cells, Cell A14 would need to be John Smith...

I wish I was good at code, but sadly I am not. I am sure this one is SUPER EASY for you guys... I want to enter 1 into cell A15, 2 in cell A16, select a15 & a16 then autofill the subsequent numbers 1...whatever through to the last line that has data in column b. This is the last few lines where...