help for Automatically delete empty row after copy range.

Friends I was working on a project with this forum time to time help we solving our above problem & almost we solve.. but only 3 problem still not solving which is following.

1. After transferring data (2 range data in two sheet) we want in one sheet where we transfer data…. if ANY ROW FOUND TOTALLY BLANK.. THEN THESE ROW DELETE. (in file we mark yellow color row which types I wanna remove)

2. AFTER EACH ROAD RECORD WHERE TOTAL DISPLAY THAT ROW FILL ANY COLOR. SO THAT THIS ROAD DISPLAY TOTALLY DIFFERENT. (in file we mark 1st Row in color which type highlights we want)

3. After transferring every record boarder line not display.. we wanna when we transfer automatically boarder line also mark in record.

FRIENDS MY EXCEL FILE ENCLOSED FOR UR KIND HELP

THANKS

Hi Santosh226001,
try it (see also conditional formatting on the sheet 'Prarup-1')

hi nilem sir ur such a god for solving my may problem.. thank a but..

sir ur provided new VBA is work perfectally.. only one error..

if we enter 7 km or more road details in sheet 1 Row no 6 to Row no 13 then ur row delete vba works

but if below 7 kms details enter then road again empty show...

i m enclosing ur provided file with entry more record


Sir one more thing we wann show also formula in Total line insted of show total Value in Colum E & F

sir if increase kms etnry details sheet1 8 km to 50 kms or any numbers then where we change in VBA pls also sugget with comment option in VBA


thanks

Hi Santosh226001,
see attachment

Thank you so much sir it's perfectly.. & i also understand in case of increase entry line then where we change in code..

Thanks you so much...Nilem Sir..

Nilem Sir as per ur provided file that file works perfectally but we add one more facility in this file that is editing record.. which one we save.. We call Data in Edit sheet with selcted roads which one we want to edit.. (actually we use ur provided VBA in one other thred load purchase form codeing.. and apply in my sheet) but we want few more Extra item to add in that code.. my example file is attach..

What i want which is i mention with COMMENT INDICATOR in particular cell & colums..

we want few cell data (eg total length, Start Chaineg Nos, End Chaineg Nos. etc) from other sheet (i.e. prarup-2)..
We want separate road category & nos when we call data.... (as excel left & right function works that type)
when we press Y then copy range as per entry sheet working that same..

My File is attache

Hope u will help me one more time...
Thanks in advance..

Nilim sir can u help me to solve above problem which is mention in post No #6

so that we can easily work with VBA..

Nilim sir

With forum & internet search we solve litile bit problem to my edit data sheet macro (code) file is enclosed ffor ur kind persual.

Now We want only 2 thing

1 in Edit Sheet column B we want a formula value which is colum D value *3.5

2nd When we press y then record update in both sheet prarup1 & prarup-2

hope now u will show interest to my vba

Thanks in advance


My updated sheet is enclosed..