Hi,
I have a spreadsheet that gets information added to it a couple of times each year. I want to be able to select that information, no matter how much information is added to it, and paste it into another spreadsheet. In the spreadsheet that has all of the information in it, there are two cells that have a value in each one showing how many rows and columns to select. The value for the number of columns doesn't change, but the value for the number of rows will change. I need some help to create a VBA code that uses these cell values and selects that number of rows and columns to copy and paste in another spreadsheet. For example, if the cell V1 has a value of 27 (for the number of rows to select) and cell W1 has a value of 18 (for the number of columns to select), I would like for the VBA code to use those values to select the cell range A1:R27. When another row is added, making V1 have a value of 28, the VBA code needs to select the cell range A1:R28.
Thanks,
Bookmarks