I have three worksheets called "NTHSCOT" "SOUTHWEST" and "LONDONSE".
I have a fourth called "NATIONAL"
What I need to do is have the data sent (hopefully automatically, second choice a command button) to transfer the data from all 3 sheets onto the national sheet. I only want the data to be transferred to the national sheet if cell A of that row contains data. If this is blank, then I do not want data from that sheet to be transferred, and then move onto the next worksheet. The data will be constantly updated, so I need the macro to "reset" itself, so it will also check all old data on the sheets and update where appropriate.
Hope someone can help me or guide me, as I am a complete novice to macro's and do not have any idea where to start with this!
I have a fourth called "NATIONAL"
What I need to do is have the data sent (hopefully automatically, second choice a command button) to transfer the data from all 3 sheets onto the national sheet. I only want the data to be transferred to the national sheet if cell A of that row contains data. If this is blank, then I do not want data from that sheet to be transferred, and then move onto the next worksheet. The data will be constantly updated, so I need the macro to "reset" itself, so it will also check all old data on the sheets and update where appropriate.
Hope someone can help me or guide me, as I am a complete novice to macro's and do not have any idea where to start with this!
