Forum Discussion
Need macro excel to show data on change of heading
Deleted
Here is the workbook with the updated code.
HansVogelaar i totally appreciate your efforts and time you are putting for this and thanks for providing me this sheet. you are awesome. u hv deep knowldge n hand on in excel programming. kudos to u.. n keep it up.
i hve one question. In sheet 2 result tab since i hv placed the table in "D14" i tried to add heading and some more content as information in that sheet and decorate the sheet beside this result table then it is giving me some offset error. i am not able to add any content above D14 or below and beside the table.
Deleted
If you want to add extra information on Sheet2, keep at least one empty row above the summary range, and one empty column to the left. Otherwise it becomes too difficult to keep track of which range the code should clear. It's dangerous to place data to the right or below the summary range: it might be overwritten when the summary range expands.