I need to develop a macro that will read all data in one worksheet (“Data”) and copy/paste it into another worksheet (“Report”), inserting a new row for each row copied from the other worksheet (“Data”).
The five columns in both sheet are the same. The data in (“Data”) starts on A2 and will be copied onto A5 in (“Report”). But the “Report” sheet is formatted for visual display/presentation. So the insertion of a new row is important here.
Any help would be appreciated!