by PSB » Mon Jun 06, 2016 2:00 pm
Hi, I periodically need to copy a row or column of sequential data and then paste the data with some number of columns or row separating each value. This is better illustrated with an example. If I copy cells A1 through E1 I would need to paste the data from A1 in cell A5. The contents of B1 would go in D5. The contents of C1 would go in G5. The contents of D1 to J5 and lastly, the contents of E1 would get pasted into M5. They key is that spacing required is a variable but, it's always the same value. In this case, I leave two blank cells between each value. The next time it might be 3 or 4 or 1 blank cell. Ideally, I'd highlight the data, invoke the macro, it would ask me to enter a value (the number of spaces between each cell pasted) and then I'd click on the cell where I want to start pasting the values. This sounds difficult because you’re dealing with clipboard data and not just a single cell. Any guidance would be much appreciated. Thanks!