Forum Discussion
Need macro excel to show data on change of heading
Deleted
Here is the workbook with the updated code.
HansVogelaar i m not making complicated. I downloade this sheet from a tool which exports data dynamically in sheet 1.
The format in sheet 1 is not constant it dynamically changes with data every 2 mins. Sometimes the tool adds new columns in the sheet or sometimes not dynamically. Position of columns are not fixed and defined in sheet 1.
Actually i want that code should read Sheet 1 Data and can run the functionality of Sheet 2, Sheet 3 and Sheet 4 no matter how many columns and rows are added in Sheet 1.
Only constant part in sheet one is headings. Even row no 1 "Table" is also not required in sheet 1.
Deleted
As for Sheet2: I already mentioned that you should leave at least one empty row and column around the summary table, and that it is dangerous to place information to the right and below it. If you want to 'decorate' Sheet 2, place all the extra information at the top, and the summary table below it.
So in its current state, it won't work.
In the attached version, I have updated the code behind Sheet4. It should now handle inserting new rows and columns.
HansVogelaar it's ok.. not to be sorry... u helped me to the fullest.
Thanks for your all your efforts, and your time. Your are wonderful and have good hands in programming
All the best !
Deleted
I'm afraid this is beyond the scope of the help that I can offer you, sorry.
HansVogelaar Pls check attachment.
I have included a sample graph. i want to link the data shown in sample graph with sheet 4 with the latest sales record data (Example from row no 31).
the graph should change dynamically as and when the data of sheet 4 gets refresh with new latest data at the bottom.
Deleted
Can you provide an example of what the chart should look like? Thanks in advance.
HansVogelaar - Hi, will it be possible to create bar graph using sheet 4 data.
HansVogelaar Thank u.. for sheet 4