Select range of cells to copy/paste values based on contents of a different cell

Hi to all you experts.

I have a problem that I just cannot solve and hope you can help me with. It may require code or a simple formula/function. Basically I wish to copy data (that could be text or numeric) from row 3 on (sheet 1) and paste the values into a different sheet. The data is spread over 16 columns [B(3) to Q(3)] but I wish to select the required number of columns based on the manually entered value in A(2). So if A(2) contains the number 9 I only wish to select the first 9 columns in the range i.e. B(3) through J(3) alternatively if A(2) contains the number 15 the selection range would be the first 15 columns B(3) through P(3).

Any help would be greatly appreciated.

Originally Posted by alansidman

try this:

Change up the destination as needed

Please Login or Register  to view this content.

you guys are amazing...that's great! thanks for that