Hi,
I am trying to create a 3 sheet document where 'Sheet 1' is a table where columns A to G are filled in then you would click a submit button (or something along those lines) and this would create a new row on 'Sheet 2'
'Sheet 2' is where Columns I-P will be filled in with information and once a date: 'DD/MM/YYYY' has been entered into Column P, it will then shift this information over to ' Sheet 3'
'Sheet 3' would then act as an archive.
I have limited experience using Macros, conditional formatting etc. so would appreciate any help possible.
Kind rgeards.
A
I am trying to create a 3 sheet document where 'Sheet 1' is a table where columns A to G are filled in then you would click a submit button (or something along those lines) and this would create a new row on 'Sheet 2'
'Sheet 2' is where Columns I-P will be filled in with information and once a date: 'DD/MM/YYYY' has been entered into Column P, it will then shift this information over to ' Sheet 3'
'Sheet 3' would then act as an archive.
I have limited experience using Macros, conditional formatting etc. so would appreciate any help possible.
Kind rgeards.
A
