Need a Submit Button that will move multiple lines of data to a database on another sheet

**shambaughj** · 06-20-2013, 04:40 PM

I'm looking to add a submit button to my form that transfers the information to the master sheet.

Data should transfer like so:

CDIS Lookup -> Master
A3->A2
C3->B2
N3->C2
T3->D2
Z3->E2
AA3->F2
AB3->G2
AC3->H2
AD3->I2
AE3->J2

This will be used on a daily basis. The problem is I'm not sure how many lines I need to transfer at a time. It could be anywhere from 2 to 200. So basically I want to make sure all ACTIVE cells are being transferred. Is this even possible?

**Break_Point** · 06-20-2013, 06:05 PM

Using VBA you can determine the last row of you data set and select the range based on the variable (the last row).

Determining the last row of your data (Assuming it is in column A):

LastRowColA = Range("A65536").End(xlUp).Row

Selecting your range with the variable of the last row:

Range("A1:A" & LastRowColA).Select

Need a Submit Button that will move multiple lines of data to a database on another sheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need a Submit Button that will move multiple lines of data to a database on another sheet

Re: Need a Submit Button that will move multiple lines of data to a database on another sh

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions