I’d like to copy cell data only which has value to other excel file. Is it possible?
- Copy to clipboard
- Paste to another excel file (Ignore ‘Null’ or ‘Empty’ field)
Another excel file already has column name as default(In and Out) So, only A2 and B2 need to be copied.
And Second Q is I need to repeat this action several time with another excel file.
Can I paste the new value from the next cell which has value?
Thank you always !!!