Hi all, Would a kind person write me a macro formula that I can copy and paste into my worksheet. I used to work with excel in my job, but I've been retired for years and have forgotten how to use it.
I have a sheet named 'Data Input', Cells B3-G3 and I want to copy the data from these and paste it into a list of data in a sheet named 'All'. Once this is done, I would like to 'clear' the data from the 'Data Input' cells ready for the next set of data.
I have had several attempts at doing this myself, but I keep getting data into the wrong cells or overwriting previous input.
I'd be so grateful if someone could help out please. I think I've lost it!
I have a sheet named 'Data Input', Cells B3-G3 and I want to copy the data from these and paste it into a list of data in a sheet named 'All'. Once this is done, I would like to 'clear' the data from the 'Data Input' cells ready for the next set of data.
I have had several attempts at doing this myself, but I keep getting data into the wrong cells or overwriting previous input.
I'd be so grateful if someone could help out please. I think I've lost it!