Very much a learner here.
In an Excel spreadsheet I can calculate the location of the next empty cell, which could be anywhere within 300 rows and 10 columns, depending on various situations.
That location is identified in say K4 as being for example G12. I need to copy and paste a number from say B4 to the cell G12.
No matter what I try I finish up going to K4 every time (or getting error messages ! ). How do I tell the operation to go to the nominated cell instead the one that nominated it?