Macro to Create Table

**saravanan1981** · 10-13-2019, 04:03 AM

Hi,
I have sheet "Data". based on the records in sheet "Data", Need to insert figure in table in sheet "Result"

Table format to be same as given in sheet "Result".

Most important is The age band will change data to data

for e.g. 0-18, 19-25 etc.

Also income band also will change data to data

For eg 2,00,000 or 25,00,000 etc.

The number of rows and columns deleted or added accordingly.

**saravanan1981** · 10-14-2019, 04:53 AM

can any one help me on this?

**PaulM100** · 10-14-2019, 05:25 AM

You could use some sumproducts instead of a macro if you set your tables and data properly, instead of VBA.

**saravanan1981** · 10-14-2019, 06:41 AM

My data is Dynamic. It Will change from time to time.
Firlds like band and income band will change. Hence need VBA

**PaulM100** · 10-14-2019, 06:57 AM

If is dynamic, then use pivot tables instead of formulas. See attached.

**saravanan1981** · 10-15-2019, 12:43 PM

I have so many similar sheets. Hence I want a macro to the dask.

The range differs every time in every sheet.

Macro to Create Table

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Create Table

Re: Macro to Create Table

Re: Macro to Create Table

Re: Macro to Create Table

Re: Macro to Create Table

Re: Macro to Create Table

Thread Information

Users Browsing this Thread

Similar Threads

How to create a dynamic macro that will create pivot table

How to create a macro to create a pivot table on a new sheet

Create a macro to create a pivot table in a worksheet

Macro to create a new table

Anyone has a macro to create a table?

Macro to create a statistics table from another data table (containing merged cells)

[SOLVED] Macro to Create Table

Bookmarks

Bookmarks

Posting Permissions