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!

  • Congratulations strongm 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: leatherland
  • Order by date
  1. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    Hi, @SkipVought, that works perfectly alright. Thank you so much for your help :) 5 ***** & @Deniall, DaveInIowa, zelgar Thank you guys for your inputs.
  2. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    Hi, SkipVought, That's absolutely brilliant. You have provided exactly what I wanted. If you can help me update the following would be great: 1) Sometime the start and end value are closer and in that case cells on the left and right are empty. Can it continue to fill the rest of the row...
  3. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    @Skipvought, "So only One range per sheet?" ---One range per row per sheet "So you only expect the values filled in one sheet at a time or for all sheets in the workbook? " --- Yes only one sheet at a time
  4. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    please find the excel file attachedhttp://files.engineering.com/getfile.aspx?folder=26fa9016-26ff-4ee6-a8fe-ac6f94a46a67&file=size_measurement_example_-_I.xlsm
  5. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    Row 2 and Row 10 has nothing to do with the requirements. I just done that to show that may make more sense, but You can ignore that :)
  6. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    May be I have created confusion. Just had a discussion with my staff and we have decided that, we are going to take a measurement for the 1st size and last size of the jacket. Meaning, First and last values i.e start and end value will be always provided. Example : jacket 1: smallest size...
  7. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    I am creating a size chart for clothing (jackets, suits etc). For example: I need to supply sizing information of the Jacket. Jacket comes in 10-12 sizes (32,34,36...50,52) so It is always difficult and time consuming to take measurement for each and every jacket. On top of that, I also need...
  8. leatherland

    Based on two cell inputs, I need rest of the cells to give values automatically

    Hi, Based on two cell inputs, I need rest of the cells to automatically calculate the differences and input the values. Scenerio 1: Eg: If I input '38 in (E1)' and '50 in (K1)', other empty cells from A1 to L1 will calculate and have their respective values automatically. So, it will look...

Part and Inventory Search

Back
Top