Posts by John19

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SIMPLY PUT: I WANT EXCEL TO LEAVE THE CELL BLANK WHEN IT ENCOUNTERS THE FIRST ZERO IN COLUM D - AND CONTINUE ON THE NEXT LINE (WITH THE SAME DATA) - SO I CAN HIGHLIGHT THE ENTIRE ROW AND VISUALLY SEPARATE THE TABLE.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I want to insert one cell line across a table of variable data, when the numbers in column D turn zero. I want to visually separate the table when numbers turn 0 along column D. Once numbers turn zero, it stays zero for the column. The data is linked so the whole line of data has to shift down, and continue on the next line. I'm thinking of shading in the line with colours to indicate where the change occurs.

Also is it possible for me to specify where the blank row is inserted - just before the 1st, 2nd, 3rd,....... "0" encountered in column "D".

Thank you

Other posts:

Shift cells one line down - when column d numbers turn zero

Shift cells one line down - when column d numbers turn zero

SIMPLY PUT: I WANT EXCEL TO LEAVE THE CELL BLANK WHEN IT ENCOUNTERS THE FIRST ZERO IN COLUM D - AND CONTINUE ON THE NEXT LINE (WITH THE SAME DATA) - SO I CAN…

www.mrexcel.com

Re: POP-UP calculated to edit balance field

do you mean I should change to 32 bit version?

Re: POP-UP calculated to edit balance field

forum.ozgrid.com/index.php?attachment/70715/I get an error message

I need a POP-UP calculator to edit balance field

[INDENT]I want to be able to add or subtract my BALANCE figures, using a POP-UP calculator - that appears when I select an icon next to any balance cell.

I'm looking for something similar to the pop-up calendar by "XLTools" Excel Add On, but with a numeric keyboard to add or subtract to the existing. A small icon appears to the right of the cell, which you select if the pop calculator is needed.

If I need to, I want to be able to edit the balance with the computer keyboard ar normal without any hindrance from this pop-up function. So If I don't select the function icon, the balance cell is as normal.

NOTE: on the pop-up keyboard, if I do not select ADD or MINUS first, the number entered should replace the existing. If ADD or MINUS is selected first then calculation (+ -) on the existing balance should be done. Selecting any other cell finalises the calculation and closes the pop-up.

PLEASE SEE ATTACHED EXCEL SHEET FOR MY BALANCE TABLE
forum.ozgrid.com/index.php?attachment/70713/
Thank you

Also posted in:
http://www.excelforum.com/show…711&p=4530291#post4530291
http://www.mrexcel.com/forum/e…ce-field.html#post4692352

[/INDENT]

Re: Problems getting external data from the web

i've just tried setting up the web query for the same site on another computer and it work? don't understand why it worked on the second computer because its same excel 2010 but its done.

thank you anyway

Re: Problems getting external data from the web

the data is off the site as it is, no login. the site is updated regularly.

the import button i mention is in web query

how do i use your code?

I'm trying to import data from the site below by setting up a new web query, but the import button is always greyed out. I've tried changing all the web query options but no luck. Can anyone suggest how I can get data into excel from this site?

thanks

http://www.tradingeconomics.com/country-list/rating

I have also posted this question at:
http://www.excelforum.com/exce…-the-web.html#post4218163

Re: highlight horizontal row - please help

perfect! thanks solved

Re: highlight horizontal row - please help

this works well, but is the a way to unhighlight when any cell outside the table is selected?

Re: highlight horizontal row - please help

so for example, selecting any of the cells along item no. 14 (USD/CNY) would highlight entire row C23 to Q23

Re: highlight horizontal row - please help

I suppose anything that would make it stand out from the rest, but I was thinking of a fill colour highlight with its own font colour so it stands out, or maybe just the fill alone?

also just rows, no column highlights

thanks

I have a currency table (see attached) and want to be able to highlight entire row (1 to 48) whenever I select any cell within the table - from cell C10 to Q57. So the horizontal cells corresponding to the selected cell should be highlighted from C to Q.

I don't want the horizontal highlight to change my black background colour outside my table, or interfere with my cell fill or text colours (I could play around with colours to solve this later myself maybe).

please please help me, I looked around so long but found nothing.

Thank you

I have also posted this question here
http://www.excelforum.com/exce…ntal-row-please-help.html

Re: Web query refresh faster than 1min

I'm using excel 2010 and don't get view code when I right click excel icon? (just restore, minimize and close)

Re: Auto Hightlight Entire Row - only when active cell is on specific columns

it gives me a black background and appears to work, so thank you very much for your effort. This whole problem is now all resolved and complete.

cheers

Re: Auto Hightlight Entire Row - only when active cell is on specific columns

for the background colour issue i've changed your code "ColorIndex = xlNone" to " ColorIndex = 1" - is this right or anything else to change?
thanks

Re: Auto Hightlight Entire Row - only when active cell is on specific columns

yes! exactly what i was after., perfect. thank you.

Re: Auto Hightlight Entire Row - only when active cell is on specific columns

sorry to ask for so much but how can i also change the code so that instead of the entire row being highlighted - only columns B to R are highlighted (that's the row from B to R).

Re: Auto Hightlight Entire Row - only when active cell is on specific columns

just realised something, it has changed the back ground colour of my worksheet to white from black. is the a way to prevent this? looking at the code i can't figure it out? i want it to leave the background all black, i don't want it to change any other colours i use on the sheet.

thanks

Re: Auto Hightlight Entire Row - only when active cell is on specific columns

perfect! thank you

Re: Auto Hightlight Entire Row - only when active cell is on specific columns

thank you.

is there a way to change the highlight colour or format?