locate

Does anyone know a way to make excel show a "cross-hair" on the cell you have selected? Something that highlights the fill of the rows and the columns intersecting the cell you have last clicked on (nothing permanent, I don't want to be changing the fill of other cells), more as a means to make...

I have a spreadsheet that I want to look up a certain row that is determined by a match formula in column 'A' but the information/price is in column 'C' any ideas of how i can get it to display the value to the right in 'H'...

Hi All, I wrote a bit of code that's been working great until now. :( The Records have reached over 1100 entries and my code doesn't do what I designed it for anymore. I just need the segment of code to locate a record number in column "A" and make that the active cell. The offending code...

Hi I have an address field and i need to split into 2 columns, but i need to do this at the 2nd space i.e. flat 21 the avenue i need column A= flat 21 and column B= the avenue has anyone got a formula that will do this (no macros please i am not that clever:))

I'm working an a bakery as an accountant. Kinda. We get the order from the shops, calculate the total for each kind of bread, croissant (there are 70 sorts of them) and send them to the bakers to make the bread. We also have to input this data in our accountant software, we have to 'bake' the...

Hi I want to create a spreadsheet where i can have a macro button embeded in a cell and when the user clicks the button, the cell to the right of the macro button displays some text. The problem i have is that the button can be placed anywhere on the spreadsheet so i can not hard code the...

I have a KPI report that I would like to to automate with VBA code which I have been able to do where there was only one score from each region for each company but I am now stuck when the second scores are added to the same list, PLEASE HELP. The headings to the columns that I need to filter...

Hi Hope someone out there can help me with this one, im trying to identify the duplicate that i have on my spread sheet, i found a really good VBA code that work really will but the problem that i have is that i dont know how to amend it to show across several column (basically i want to to...