Recent content by ksquared

  1. K

    Solved Excell Help add a leading 0 if cell contents has only 4 char

    Hi, I need a formula (=if etc.) to add a leading "0" if the contents of a cell are only 4 character. SOrry, never mind. I started this tread in error and need to figure out how to delete it.
  2. K

    Vlookup breakdown

    Hello, Several on this forum have helped me with Vlookups in the past and for I am most gratefull. But rather then continuing to have someone send me the formulas, I think if I understood what the instructions in the lookup actually do, I will be able to modify the vlookups I already have...
  3. K

    Solved: Excell formula to copy contnets from 1 spreadsheet to another

    Thank-you! Both solutions worked perfeclty. I've been wondering how to bring data from one sheet into another. This will save me a lot of time. Happy New Year!
  4. K

    Solved: Excell formula to copy contnets from 1 spreadsheet to another

    Hello, I have 2 spreadsheets – A and B - in the same workbook. Spreadsheet A is sorted alphabetically (by product name). Spreadsheet B is sorted numerically (by product ID) and has quantities (how many items are in stock). I need to pull the quantities from spreadsheet B into...
  5. K

    Solved: Excel help combining fields

    Thanks XCubed. Please don't be too impressed with me writing macros. Excell has a developer tool which captures what you are doing and writes the code (VB?) for you. All I have to do know how to do it manually 1st with no mistakes along the way and then turn on the capture macro tool. I...
  6. K

    Solved: Excel help combining fields

    Thank-you again XCubed. I hadn't used a custom sort before but was able to figure it out using your instructions. I sorted Col A from smallest to large and then Col D from z to a which did exactly what I needed to do. I captured all of my keystrokes into a macro (typing out your formulas and...
  7. K

    Solved: Excel help combining fields

    Thank-you XCubed! Your formulas combined everything but I need one more change. I need to have the combined products stored in the 1st instance of the 1st appearance. Can a 3rd step be added to move the combined prodcuts to the 1st line where we started? (I may have finally figured out...
  8. K

    Solved: Excel help combining fields

    Hello, not sure how to explain this but hopefully this will work. I need to combine the contents of all the cell B’s when cell A has the same contents (in this example 2222 etc.). ........A......B line 1 2222 object line 2 2222 box line 3 2222 something line 4 2223 circle line 5...
  9. K

    Solved: excell help if contents is < or > than this value populate with this

    Hello, I need help with one more formula in Excel. If the contents of A1 is less than 75.00 and greater than 0.00, populate B1 with 8.00 Before 124.75 22.95 38.00 144.00 31.95 After Col A________Col B 124.00 22.95 .............8.00 38.00..............8.00 144.00...
  10. K

    Solved: excel help if field is blank copy contents

    That's perfect. I should have said formula. Just don't know my terms too well. Thank-you for your help. Much apprecaited.
  11. K

    Solved: excel help if field is blank copy contents

    Hi, I need help with a macro. I want to copy the contents of the cell above into the cell below if the cell below is blank. A1 1234 B1 C1 5678 D1 E1 2345 F1 etc. so it looks like this after the macro runs. A1 1234 B1 1234 C1 5678 D1 5678 E1 2345 F1 2345 etc. A1 is...
  12. K

    Excell formula help

    Some of the lines do not have an 8 in colume D. IF D1=8, add new line and populate the fields. If D1 does not equl 8 than do nothing. Again I have no idea how to write this. Thanks for responding. I've always had good luck here which is why I posted my quesiton here 1st.. I'll see if I...
  13. K

    Excell formula help

    Hello, I'm afraid I have no idea what a changesheet event is. When I googled it, it indicated that it is used to trigger an event when the contents of a cell changes. Let me ask this a differant way. What I'm looking for is either code or a formula that will add a new line whenenver...
  14. K

    Excell formula help

    WIndow 2007, XP Hello, I need some help with an Excell formula. I need to add a new line everytime a particular cell in a line has a certain value. Example: Prod Teapot ID400 8 If colum D=8, add a new line and populate cell 2B=SP and cell 2C - XXXX. The end...
Top