@vletm
Sorry for delay in response due to my ill-health.
i had tried some thing based on the support/ideas provided by you earlier (stripchart).
but end up with error in if statement.
Attaching the file for your review please.
Regards
Ashok
Sir,
In Strip Chart, Top Levels shall be one for any Stretch i.e. from A to B only one code will be there(i.e. top layer will be shown).
But here, The hindrances for any particular stretch may contain one or more. (i.e. From A to B, one (or) Multiple Hindrance may be there)
Note: The Hindrance...
thanks for reply,
same as above, the logic is the hindrance should be same from point f to G or Point G to point H. (as A&B or A&C or B&C or B&D or individual A or B or C or D ...)
@vletm
Hi Sir,
Good evening and Thanks for your response.
I am preparing the same manually. the procedure i am adopting is as follows.
1) as My road starts from 128850, i checked the status at the starting chainage. thus the road from 128850 to 129000 is clear from hindrances and so...
Dear Sir,
I am working in a road project which starts at Km 128850 to Km 272571, which contains obstructions / hindrances in some strips on Left Hand Side "LHS" or Right Hand Side "RHS".
The type of Hindrances are
1. LAQBalance 9.18%
2. Non payment
3. Structure obstructions
4. Trees...
Hi,
May be i didn't explained clearly.
In work sheet named "bar chart" i have data in range C1:UFX4
I have to paste special the values in the above range to following ranges in worksheet named "Highway Strip Chart".
Brachart ----> Highway Strip Chart
C1:BA4 C6:BA9
BB1:CZ4...
Hi,
In work sheet named "bar chart" i have data in range C1:UFX4
I have to paste special the values in the above range to following ranges in worksheet named "Highway Strip Chart".
C6:BA9
C16:BA19
C26:BA29
C36:BA39
.....
upto...
C2826:BA2829
uploaded the sample file for your reference...
Hi,
I am using a macro (Found in internet) to merge the adjacent cells having same values.
Working fine except it is merging even the cells are blank.
I need to skip the blank cells (without merging).
Attached the file for reference.
Thanks
Ashok
@Shan Li
ok, now you want to lookup the the data range.
Your data is having same values in column"A" with different values in corresponding columns.
what EXACTLY are you wanted to do ???
what "return value" to be placed in Column J?
Ask the question in proper section if you need VBA solution.
@Shabana
checked your file and few questions.
My understandings are
> Machines K1 to K7 will produce X no of products day.
> All machines will not work on holidays.
> Orders will be allotted to machines based on their availability.
> Any machine will be allotted with another order after...
@bts1969
Option Explicit
Sub show_hide_columns_color()
Dim cell As Range
Dim button_color As Long
For Each cell In Range("H2:J18") 'Change range to suit
If Not cell.Interior.Color = 65535 Then
If Columns(cell.Column).EntireColumn.Hidden Then
Columns(cell.Column).EntireColumn.Hidden = False...
@NARAYANK991
thanks for your reply.
I had corrected the mistakes, but the following code is giving mistake.
PrivateSub CommandButton1_Click()
rfi.Show
EndSub
Uploaded the modified file. Can you please check.
Note: I am using Excel 2016
Thanks
Ashok
Dear sir,
I am trying to enter data with the help of user form named "RFI".
I had prepared the user form and created a command button named "RUN" to show the user form "RFI" and assigned following code.
Private Sub CommandButton1_Click()
rfiuserform.Show
End Sub
&
While clicking the...
@NARAYANK991
While using the macro "FillDown", Remaining cells are filled with value"0" (for ex. A1, B1:B3, C1:C6,...)
But using the macro "Fillup", remaining cells are NOT filled with value "0".
Can you modify the macro "FillDown" so that remaining cells are not filled with "0".
Thanks
Ashok
@Narayan
It worked great. Trying to understand the macro.
Meanwhile, i need to to fill values in reverse order for another condition.
If cell (A2) value is 1 then range A1:A2 values has to be 1.
Likewise for columns B:L,
Attached the output file for your reference.
Thanks for your help.
Ashok.