How to copy and paste data from one tab to another tab with Macros?

**simplyfocus** · 07-30-2012, 02:43 PM

Hi excel experts,

I am trying create an Inventory Label Program that can copy and paste data from one Tab to another base on the number of rows that the user enter. For example if the user enter 5 on the "Labels To Be Displayed" tab of Nike Short row, then the program will go to Nike short tab and Copy Column A2,B2,C2,D2,E2,F2 and fill it to A2:F2 and 6 rows down in "Display Result" Tab. So basically it copy A2:F2 from second row and then fill it to A2:F2 6 rows down. If the users enter 3 in Nike T-shirt rows then it will copy A2:F2 from second row and then fill it to A2:F2 4 rows down.
Could anyone please suggest what I should do? Or maybe help me write a short macros example?

Thank you,

Peter

**arlu1201** · 07-30-2012, 02:48 PM

What about the price column in the Nike Shorts tab? All columns have the same info except the price column. So when the autofill happens, should it just take 1 row and make copies of it (so the price remains the same) ? Or should it copy the current row + no of rows user asked for? So if user asks for 3, it will copy the current row + 3 rows (so price changes) ?

**simplyfocus** · 07-30-2012, 03:04 PM

Arlette,

Thank you so much for your quick response. I re-uploaded the file. Assuming the prices are the same. Basically the number that the user enter is how many rows "Nike T-shirt Nike Blue W888901 W88901 $110 " the result tab should display. I then use this result tab to print out label. Instead of copy and paste 50 rows down. the user can just enter 50 in the "Number of Labels To Be Displayed" tab. I will have 50 rows of labels on the "Display Result" tab. But I am not sure what to use to run this function.

Thank you so much for your help.

Peter

**rvasquez** · 07-30-2012, 03:05 PM

Hello there attached is your worksheet updated to include a command button and macro that runs that I believe achieves your results.

Let me know if this works for you!

Thanks!