Need Macro to perform TEXT and SUM function in multiple worksheets

I tried to replace the text function with following code. I didn't ran into error but there was nothing came up in the cell C3 either. Could any help?

Please Login or Register  to view this content.

Originally Posted by alexxgalaxy

I tried to replace the text function with following code. I didn't ran into error but there was nothing came up in the cell C3 either. Could any help?

Please Login or Register  to view this content.

Try this...

Please Login or Register  to view this content.

And this...

Please Login or Register  to view this content.

Thank you Alpha Frog! They worked wonderful, separately.

I came up with another problem when I tried to put them together as follows, though. Actually, besides the date, I also did came up with other more codes including adding rows & columns, formatting some cells. I tried to put MyDate's codes before "Next i" and another time after "For i = 3 To sheets.Count" but both didn't work. All it did was that the Inputbox message popped up for every sheets (starting the 3rd one) but at the end except on the 3rd sheet, the value of C3 was empty in the rest of the sheets. I didn't try further with the other codes because of the failed attempt with MyDate's code

May I know where shall I place these codes so that they would work on every sheets (except the first two)?

Please Login or Register  to view this content.

Okay, I sort of solved part of the problems by putting the following code I searched from the net after the Sum_ColumnF_Rows codes, followed by those add-rows-columns-values-formatting codes. Still, I couldn't make the MyDate codes work on every sheets starting from the 3rd one.

Please Login or Register  to view this content.

It would be better if you simply described what you want to do.

This will prompt you once for the date and then put that same date and the sum formula for each worksheet after sheet 2. Is that what you want?

Please Login or Register  to view this content.

Thank you so much, AlphaFrog! This works perfectly and is definitely neater.