I have data in a spreadsheet and i'm copying the data in a template with
contains headers. My problem is how do i update the headers as the data
changes.
Example of Data:
Region District Dealer Data
Central 2 1064 200
Eastern 3 2514 300
My data consists of alot of regions and Districts and so on. So lets
say i'm done pasting Central region and i go on to Eastern, how do i
change the headers using
VB code while copy that chunk of data.
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/