Hi,
@SkipVought, that works perfectly alright. Thank you so much for your help :) 5 *****
& @Deniall, DaveInIowa, zelgar Thank you guys for your inputs.
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...
@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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.