blarkdirth
02-09-2005, 08:18 AM
Hi All
I would be grateful for some help on the following challenge
On Sheet 1 in various cells eg A3, B3, C3 a user will input values
At the press on a Button on the sheet I would like the values to be transferred into the next completely blank row on sheet 2, in columns E, F, G.
The row to transfer into has columns up to AY
If any of the cells in a row up to AY has a value then the row should be viewed as not blank
Appreciate any help
Mark
I would be grateful for some help on the following challenge
On Sheet 1 in various cells eg A3, B3, C3 a user will input values
At the press on a Button on the sheet I would like the values to be transferred into the next completely blank row on sheet 2, in columns E, F, G.
The row to transfer into has columns up to AY
If any of the cells in a row up to AY has a value then the row should be viewed as not blank
Appreciate any help
Mark