Hi there, I have the following table input:
I want to be able to transfer this input data into another worksheet log whilst combining the information. For example I need the sample #s, lot #s and amounts supplied to transfer into a single cell on the next worksheet in the following format:
1A 1.60ml
2B 5.00ml
3C 3.50ml
I have the following code thanks to some helpful people on here! The first issue I'm having is that I need to ignore any blanks from the input sheet when the data pastes over into the second worksheet otherwise I just get a lot of new lines within the single cell with just "ml" stated such as:
1A 1.60ml
2B 5.00ml
3C 3.50ml
ml
ml
The second issue I'm having is that I'm attempting to paste into the next available cell on the second worksheet once a new input has been made however from my code nothing is pasting over, I know it's probably something very simple and I've completely missed but any help with this would be greatly appreciated, I'm very new to vba so any guidance would be great
I want to be able to transfer this input data into another worksheet log whilst combining the information. For example I need the sample #s, lot #s and amounts supplied to transfer into a single cell on the next worksheet in the following format:
1A 1.60ml
2B 5.00ml
3C 3.50ml
I have the following code thanks to some helpful people on here! The first issue I'm having is that I need to ignore any blanks from the input sheet when the data pastes over into the second worksheet otherwise I just get a lot of new lines within the single cell with just "ml" stated such as:
1A 1.60ml
2B 5.00ml
3C 3.50ml
ml
ml
The second issue I'm having is that I'm attempting to paste into the next available cell on the second worksheet once a new input has been made however from my code nothing is pasting over, I know it's probably something very simple and I've completely missed but any help with this would be greatly appreciated, I'm very new to vba so any guidance would be great
