Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating Headers using VBA
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
Headers | Excel Discussion (Misc queries) | |||
Updating Headers/Footers in VB | Excel Discussion (Misc queries) | |||
Headers | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |