Data auto transfer

[tomas262]

Hi there, I have a table where I insert data manully. I need to create next table on next sheet/same workbook for exporting purposes which will automatically copy (download) data from original table.

So when I insert a new line into the original table and insert new items, it will create a new line in "exportable" table automatically and copy data. Is something like this possible?

I use "format as table" function of 2007 for data structures.

Thanks

 

[texasalynn]

so are you just recreating on the "exportable" the exact same data? Is the next sheet one that is existing? Is the sheet name "exportable"?

 

[tomas262]

yes, same data. The reason for this is that export must have different column order and may not include all columns of the "mother" table ... sheet name can be "exportable"

 

[texasalynn]

yes, same data. The reason for this is that export must have different column order and may not include all columns of the "mother" table ... sheet name can be "exportable"

then it is NOT a straight copy. Post a sample of the input data and export data layouts