Search results

Hi Narayank, That is exactly what I needed, and is perfect. Thank you so much for your help! Mike

My data is in C2:C50. So it is in one column, but several rows.

Thanks very much for your reply Narayank, however when I put this into my spreadsheet, the point only appears on the vertical axis, does not appear across the length of the line graph?

Good morning all, Firstly I love the new forum! I am having a problem with a line graph I am creating. Basically, I am creating a line graph to track costs for certain items. What I need is to be able to create a straight line that will always sit at £10,000 on the line graph. So if an...

Thats perfect thank you. I tried along those lines, but there must have been a part of the formulae I was getting wrong so it wasn't working, or bringing back wrong results. This is perfect thanks very much.

Good day all, I am trying to use Index and match to achieve a kind of reverse v look up. What I need is to pull out what information is in column A on sheet 1, if what is on sheet 2 column C is found. So it looks through Sheet 1 Column C to find what is in Sheet 2 C1, then makes Sheet 2 A1...

Good morning all, We currently have an excel document that is used by three people, who work on three seperate sheets. It is a shared document, so it updates each time the user saves with the changes from the other users. One thing we are having a problem with is duplicate information. What...

Thanks Sir, that is perfect for what i needed. The link is also very handy, and has been bookmarked! Many thanks :)

Hi SirJB7, any updates on this, if you have had a chance? :)

That example is very helpful, however the web browsers are actually embedded within the Excel Document. I am using the WebBrowser Object in Excel 2007, and those are the web browsers that I need bringing to front/sending to back.

Hi SirJB7, I thought about that, however WB2 does need to be visible. It has WB1 covering the bottom quarter of it but it still needs to be visible and accessible. So I couldn't set it to false :( Any other options? Thanks!

Good afternoon, I currently have two web browser objects on a spreadsheet. WB1 is covering WB2 as WB2 has an advert at the bottom, and the way they are now, WB1 covers WB2's ad, while its add is off screen. One of the problems I have is that on occasion, WB2 will load on top of WB1. I want...

You need to clean up your data more efficiently and it would make the task much more manageable. I was going to suggest separating it by spaces, but the delimiters range too much. If you can, set up some sort of cleaning process as it comes in to excel from whichever source, that way it will...

That pretty much is a simple example. Make cell A1 invisible (white font, etc), and type =A1 into the cell that you want the formula result to be.

You guys are absolutely awesome. With the links provided, I should be able to tinker around and make exactly what I need! Thanks very much! :D

Hi Chandoo, I was just wondering if anyone knew a way that a chart like this: http://www.highcharts.com/demo/line-ajax (data points highlighting on mouse over) was possible in Excel 2007? Either by including Javascript, or by writing it in VBA? Many thanks, Mike

Hi Nara, Unfortunately I cant seem to get that to work in my spreadsheet :( Would you have any other tips?

Anyone else have any other suggestions? Struggling to find a way

Hey Bobhc, Unfortunately not no. It doesn't seem the web browser object can be grouped with anything.

Hey Hui, I did try that, however when the web browser object loads, it ignores any "bring to front/send to back" and is always on top? Thanks, Mike

Hey all, I am currently using a web browser object to display a website within my excel spreadsheet. The problem I am having is the website has advertisements, that (like all things on the internet) can be nsfw. Is there a way to cover the bottom of a web browser object, with say a solid...

Hi Nara, Was able to download and check that file and it works perfectly. So far it is doing everything that is needed! Thanks very much for your help! :D Mike

Hi Nara, That address is currently blocked at my work. However I can test later on this evening at home. Thanks very much for your help!

Hey Nara, That sounds like the exact outcome of what I am looking for. That would keep any data that is already inputted/already on record updated, while adding new records should it be new information. Is that something that is possible?

Hi Nara, Thanks very much. It does mean that there will never be duplicates. The reference number is unique. Its the information relating to that reference number that may change. The sheet "Data" holds all current information. For the fresh data, that is copied into a sheet called "New...