Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kidnos
  • Content: Threads
  • Order by date
  1. kidnos

    Resize 2 rectangles based on numerical values but have both contained within one cell

    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...
  2. kidnos

    Excel - Using invoices with dates and $'s and having them figure out monthly contribution?

    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...
  3. kidnos

    Lotus Notes 6.5 Agent Does Not Forward Subject Line

    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...
  4. kidnos

    Lotus Notes 6.5 Agent Does Not Forward Subject Line???

    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...
  5. kidnos

    Linking/referencing the next column in a different excel sheet

    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...
  6. kidnos

    Nested IF statement - with both less than and greater than

    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))))),"-")
  7. kidnos

    Can a bubble chart in excel have transparent bubbles?

    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.
  8. kidnos

    Using excel to figure out sales contribution based on date

    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...
  9. kidnos

    Protecting/securing cells in excel

    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...
  10. kidnos

    Date Formatting in Excel

    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...
  11. kidnos

    MS Word: Cant see embedded/linked item only the tag

    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...
  12. kidnos

    Pulling From Another Sheet and Sumproduct

    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...
  13. kidnos

    Need cells to fill blue if they contain the letter &quot;E&quot;

    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...
  14. kidnos

    Creating a display window in excel

    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...
  15. kidnos

    Wireless Connection Disabled?

    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...
  16. kidnos

    List of Data and want to count them only if they are not dupes

    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...
  17. kidnos

    Pulling values from another sheet if a rows text matches another

    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...
  18. kidnos

    Getting a multiple sheets in excel to pull from other sheets

    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...
  19. kidnos

    Have a list and want to be able to populate a cell if true

    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...
  20. kidnos

    I need to conditional format in excel based the word &quot;estimated&quot;

    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...

Part and Inventory Search

Back
Top