How can I copy and paste multiple cells between two sheets?
So far I've only managed a single cell at a time by putting the value inside a variable, but the spreadsheet has many rows to do one by one.
Can anyone help me with this?
you can use keystrokes to select the cells you want and then copy and paste those cells.
Or else try Getcells to get the required values from the excel.