Excel Formula or VBA Code

[jsenglish11]

Ok so I am trying to figure out a code or formula that will copy certai
cells from lets say Sheet 1 to Sheet Test and there are 31 Sheets on
for each day of the month. But I want the value of the cell as will a
the formatting of it. I can make up the formula to copy the value but
know there isnt a way to have a formula for the formatting. Also ther
will be one cell I change the number in which would be the day in it an
it automatically changes the information

 

[Pete_UK]

Well, you seem to know that a formula cannot return a format, so that
means you would be seeking a VBA solution, as a formula can't do what
you want to achieve.

Pete

 

[jsenglish11]

Correct but I am not for sure how to create that VBA solution.

;1600940']Well, you seem to know that a formula cannot return a format
so that
means you would be seeking a VBA solution, as a formula can't do what
you want to achieve.

Pete

Ok so I am trying to figure out a code or formula that will cop certain
cells from lets say Sheet 1 to Sheet Test and there are 31 Sheets one
for each day of the month. But I want the value of the cell as wil as
the formatting of it. I can make up the formula to copy the value bu i
know there isnt a way to have a formula for the formatting. Als there
will be one cell I change the number in which would be the day in i and
it automatically changes the information.