Hi i would like data copied to a new sheet "Control Chart" once a Form control button is clicked
the data would be pasted in a row underneath existing data
the destination would be dependent on cell B1's value (which is a material description)
keeping the colour formatting is also needed.
there are 26 different material values so the sheet will be very long horizontally which is fine
Data entry and values needed
values copied horizontally for easier transfer.. im guessing?
first material pasted in cells A2:Q2
next material pasted R2:AH2
keep up the good work
this site is legendary!
the data would be pasted in a row underneath existing data
the destination would be dependent on cell B1's value (which is a material description)
keeping the colour formatting is also needed.
there are 26 different material values so the sheet will be very long horizontally which is fine
Data entry and values needed
values copied horizontally for easier transfer.. im guessing?
first material pasted in cells A2:Q2
next material pasted R2:AH2
keep up the good work
this site is legendary!