This is a bit tricky for me.
I have a Workbook called "Workbook1" in which Sheet 1 looks like as shown below. I have a a grid between dates and some alphabets as shown below
Workbook1-Sheet 1
image1.PNG
Now I have another workbook called "Workbook2" in which sheet 1 will have input as shown below. C1 will have present dates and column A will have alphabets.
image2.PNG
Now based on value in column A and date in C1 i want a macro button on pressing which we can iteratively add values in the gird in "Workbook2"
For example on pressing the Macro button present in workbook2 the grid will be updated as shown below
image3.PNG
CAn anyone help me ?
Bookmarks