Attached find a excel workbook which contains 2 sheets viz., Sheet1 & Sheet 2
sheet 1 contains some data* ( given to me) and below there is a countif function that is calculating
sheet 2 contains some formatted text and and cell referencing to sheet 1
I need to create a macro so that i can apply the countif function in sheet 1 and and the entire sheet 2 on on 75 other workbooks present in a folder which contain different data*
Care has to be taken that when you run a macro the referencing present in sheet 2 should belong to that specific workbook and not the original workbook
Is that possible? Can someone please help.
I have also attached a macro which I tried but this works only for one sheet and also the formatting is lost. Although it does apply the formulae to all the workbooks present in the folder at one shot.
Regards,Please Login or Register to view this content.
V
Bookmarks