Search results for query: *

Hi everyone! I am trying to build a table in excel (2010). Ultimately, I would like to be able to have two rectangles within a cell that automatically resize based on different numerical values. The tricky part is, I would like to autoshapes to fall within one cell and not overlap. I have my...

Hi all, I have an excel sheet that has a number of invoices that include dollar amount and the start date and completion date. So one is $200K and it goes from 9/1/2012 to 9/1/2013. If I divide the amount by 12 then I figure out the monthly contribution. However, I don't know how to automate it...

Hi all, I have been moved over to Lotus Notes 6.5 and I am trying to create an agent to forward an email with a certain word in the subject. I have successfully created an agent to do this but when it forwards the email it does not include the subject line. However, everything in the body of the...

Hi all, I have been moved over to Lotus Notes 6.5 and I am trying to create an agent to forward an email with a certain word in the subject. I have successfully created an agent to do this but when it forwards the email it does not include the subject line. However, everything in the body of the...

Hi all, I am having trouble trying to figure this out. I have cell A1 in sheet 1 which contains data going through column BA1. I have another sheet called sheet 2 that I have linked to cell A1 in sheet 1. Within sheet 2 I would like to be able to link to the other columns in sheet 1 with...

Hi all - I am trying to make this formula a little easier - it currently works but it is kind of long. Does anyone know of a way to shorten it up? Oh, I have to have the ISNUMBER check in it... Thank you =IF(ISNUMBER($O168/AF168),(IF($O168/AF168<0,"-",(IF($O168/AF168>50,"-", ($O168/AF168))))),"-")

Does anyone know if there is a way to make the bubbles in a bubble chart (within excel) transparent? I have searched and tried to mess around with this myself and have had no luck... Thank you.

Hi all, I am trying to figure out how to have excel figure out based on a date I give it figure out one complete year of revenue or sales contribution (quarterly). For example if I buy a gumball machine today and i expect it to generate $10 in 2009 and $12 in 2010. There will 23 days left in the...

Hi all. I am trying to protect certain cells in my excel models. I dont want people to be able to see or adjust what is in some columns, lets say E, F, and G, but I want them to be able to modify columns A, B, C, and D. I am not entirely sure on how to do this. I understand I can hide certain...

Happy new year everyone. I have an issue with some dates I am using in excel. I have a two rows of data (dates) that read as follows: Mar Jun Sept Dec 1Q02 2Q02 3Q02 4Q02 I would like to be able to say to excel take the last date and go forward or backwards 1. So 2Q02 -1 = 1Q02 ; Or minus 3...

I have inserted an embedded item / hyperlink into word and for some reason I cant see the link or the image, only the tag. For example, I link to winamp on my desktop and it gives me: {HYPERLINK "D:\Data\Winamp.lnk"} However, when I switch to the reading view vs. the normal, print, outline, and...

I have sheet 1 which has titles set up in column A. These titles are pulled from Sheet 2 (same column). I also have a date listed at the top of sheet 1 (in the same place as dates in sheet 2, but sheet 2 contains multiple columns for each quarter). I would like to set something up where if the...

Hi, I have a row of data in excel that pulls from another data source. It is basically a bunch of past and future dates. For the future dates they have an 'E' on the end, so it would be 2008E. I would ultimately like the cell to fill blue if the it contains the text "E". I tried to conditional...

HI everyone, for some reason I think my previous post was removed but anyway I would like to create a display window in excel that comes up when the sheet is loaded and says "check xyz" and you click ok or whatever. Similar to the "this workbook contains links to other sources". Basically I just...

My wireless Network Connection on my laptop is disabled. When I right click and select enable the status changes to not connected even though there is a connection available. When I select view wireless connections under choose wireless connection it says - windows cannot configure this wireless...

Hi, I have a list of data in column A, say: ,"365",1280 ,"476",1280 ,"596",1280 ,"596",1280 ,"40",1280 ,"41",1280 ,"53",1280 ,"104",1280 I pulled it into excel from a comma delimited text file. Well, I would like to count how man clients we have but exclude duplicate entries. So in this case...

Sorry for the somewhat confusing title. I am looking to pull information into one excel sheet from another excel sheet. I have one sheet that has the date at the top (9/10/2006) and one cell (A10) says estimated payables with the cell next to it blank(B10). The other sheet has the date in column...

Hi, I have about 30 different worksheet in an excel file. I also have insert a new worksheet for every old one I have and need to pull info from each worksheet. So, for example I will have sheet 1 and template 1, sheet 2 and template 2. Is there any way to set something up so for every template...

Hey guys, I need a little help on something I have a list of dates in column B and a list of numbers in column A. In a cell I would like to be able to enter the date and have it return the corresponding number. I have done this before but forget how. I know I use an if then but do I also use the...

Hi, I would like to format my excel workbook and its sheets so that when one of the cells (specifically in column B)says "estimated" the row, cell or text itself will be colored red. For example, in one of my sheets I have 6 columns of data and lets say row 1 in column B says Estimated AP then...