excel 2016
I have 40+ columns of data in 100s of rows.
At a specified time each day I need to copy each row sequentially to a single row in a new worksheet.
As an example:
DataSheet is the sheet from which data should be copied. NewSheet is the receiving sheet.
Process would be as follows;
copy DataSheet A1:A40 to NewSheet A1 and add 1 blank column at end.
copy DataSheet B1:B40 to NewSheet A42 and add 1 blank column at end.
copy DataSheet C1:C40 to NewSheet A:84 and add 1 blamk column at end.
copy DataSheet D1:D40 to NewSheet A:125 and add 1 blank column at end.
Continue to end of rows.
# of columns and rows may change from day to day, but will always be the same # of each on any particular sheet. NewSheet would be named according to date procedure is ran, ie; 1_23_18 for Jan 23 2018.
Seems like a combination of loops and count(), but beyond my ability to construct anything that works.
Appreciate everyone who takes the time to read this post!
I have 40+ columns of data in 100s of rows.
At a specified time each day I need to copy each row sequentially to a single row in a new worksheet.
As an example:
DataSheet is the sheet from which data should be copied. NewSheet is the receiving sheet.
Process would be as follows;
copy DataSheet A1:A40 to NewSheet A1 and add 1 blank column at end.
copy DataSheet B1:B40 to NewSheet A42 and add 1 blank column at end.
copy DataSheet C1:C40 to NewSheet A:84 and add 1 blamk column at end.
copy DataSheet D1:D40 to NewSheet A:125 and add 1 blank column at end.
Continue to end of rows.
# of columns and rows may change from day to day, but will always be the same # of each on any particular sheet. NewSheet would be named according to date procedure is ran, ie; 1_23_18 for Jan 23 2018.
Seems like a combination of loops and count(), but beyond my ability to construct anything that works.
Appreciate everyone who takes the time to read this post!