hi every one,
i want to update my sheet1 from sheet2
i have data in sheet1.range(a2:i500)
every day i do back up of work in sheet2
i want to update my sheet1 from sheet2 after backup
when i want to update and run macro
i want to popup a InputBox now
i fill a value in inputbox = 31-DEC-2016
now macro search in sheet2 and column b4:b1000
and the macro found value 31-DEC-2016 in column c and rows c94:c111
then copy the range c94:c111 and paste in sheet1 in range a2, and macro should also add new rows according to copied range..(count rows = 18)
then add new 18 rows and paste from a2
range form sheet2
[ATTACH=CONFIG]71044[/ATTACH][ATTACH=CONFIG]71044[/ATTACH]
Befor update
and
after update
sample workbook added