There is a three column data in the main worksheet named 'Main Data" of my workbook named 'BOM'. In worksheet ' Main data' there is a single cell Range named 'copy_rows' where a number is entered. On the basis of this number (Suppose it is 10) I want to copy 10 rows of this three column data to another worksheet named ' Target Data' by running a macro. I do not have knowledge to write VBA Code.

When I change the number from 10 to 18 in the single cell Range named 'copy_rows'and run the Macro it must copy 18 rows to worksheet "Target Data"

  • 1
    Are you asking for help with the VBA code to write the macro? Do you want to learn VBA? Or would a cell formula solution be OK? – Joe P Jun 5 '17 at 13:09
  • It will be very easy to reference the "source cell" to "target cell". Just put =A1 or whatever the source address on the target cell. – Vylix Jun 5 '17 at 13:53
  • cell formula solution is what i am looking for. – GS Puri Jun 6 '17 at 18:35

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.