Copy number of rows based on cell value

Hey all,

I have the following VBA code which copies a range from a particular sheet and pastes the data to the last available row in another master sheet (database). The problem is I want to copy the number of rows based on a cell value in one of my sheets.

For example, if my number is "2" I only want to copy the first 2 rows (range B2 to R3), if this number displays "3" I want it to copy the 3 rows (range B2 to R4) etc.

The below code means I am just pasting all of my maximum 4 rows across to the database when some of these fields are blank.

Please Login or Register  to view this content.

Hello DaveNUFC
,
Which cell on which worksheet of which workbook is this value to be found?

Hello DaveNUFC,

If I understand you correctly then this should work.

Please Login or Register  to view this content.