Hi All,
So I'm trying to get a button on a spreadsheet to copy and paste data into a database. I have a static range that I need to copy and I have a range that is going to be changing (but will always start at E10 and F10) and will have blank spaces between the data too that I dont want. I want to be able to copy and paste the static range and loop that to include Ranges E10 and F10 down. But columns E and F will have blank lines between the data I dont want to copy. THere will however ALWAYS be data in column D that will be next to any entries into Columns E or F.
Going to upload a workbook to try and help explain what I mean... Hopefully it makes sense? I just cant seem to figure out the best way to do it. I tried a loop of the whole "With rws" bit and tried a dozen copy and pastes but nada!
Any help would be much appreciated!
Bookmarks