Add header into Excel table

J

jonesaa05

Hi,

How can I add header(cells in first row) to the sheet which is created
after I copied values from other sheets?

Eg. values copied are like this

2003 |June| James| 250
2005 |May| John | 1001

So, the header would be
Year|Month|Name|Amount

Thanks in advance,
amy
 
J

jonesaa05

Sorry, I should clarify that the values are copied from different
sheets into one sheet using macro.

Only certain related cells are copied, so I have to add title in the
columns myself. So, what I mean is after the values are copied (run the
macro), can I also add title for each columns as well. I don't want to
type in manually. Is there any ways to do this?


Thankyou.

amy
 
Top