Hi,
I have an excel sheet with macro enabled. The macro copies the data from another workbook to mine. Then in my sheet column ‘AP’ I have given a formula which calculates the week based on the date in column ‘J’.
The formula is =IF(J2="","",CONCATENATE("Week ",WEEKNUM(J2,21))). The formula works fine till row 232. While running my macro after row number 232, the formula changes automatically to row 356.
For example:
Till row 232 the formula is
=IF(J232="","",CONCATENATE("Week ",WEEKNUM(J232,21)))
In row 233 the formula changes automatically to
=IF(J356="","",CONCATENATE("Week ",WEEKNUM(J356,21)))
Can anyone help me out in this case.
TIA,
Gautham
Bookmarks