Good morning, I am looking for advice on how to start with a problem I have.

I have a sheet where users input information. The data is stored in 6 rows, E7:I12 with each row being a new record.

I would like a macro which can achieve three things

1. Only copy rows where the E column is not blank

2. Copy and insert the non blank rows into a table as new rows, called TblTest

3. Copy and insert a value from cell F16, in an additional column in the tblTest along side each non blank record.

The user input information is contained on worksheet “Calc”, tbltest is in worksheet “MyTotal”

What is the best way to achieve this?

I look forward to and appreciate any assistance.

Smillie

​Good morning, I am looking for advice on how to start with a problem I have. I have a sheet where users input information. The data is stored in 6 rows, E7:I12 with each row being a new record. I would like a macro which can achieve three things 1. Only copy rows where the E column is not blank2. Copy and insert the non blank rows into a table as new rows, called TblTest3. Copy and insert a value from cell F16, in an additional column in the tblTest along side each non blank record. The user input information is contained on worksheet “Calc”, tbltest is in worksheet “MyTotal” What is the best way to achieve this? I look forward to and appreciate any assistance. Smillie  Read More

​