macro for saving multiple rows of data to new sheet

**stephen1000** · 04-14-2009, 10:25 AM

Hi Guys,

I am looking to save a range of data from an input sheet, to a data sheet.

I know how to save indivdual cells to a worksheet in the form of a data

what i am looking to do is save A6 - J6 down A19 - J19, but only saving the data which is entered

A6 - J6
A7 - J7

I hope I have explained myself correctly.

Cheers in advance

**Leith Ross** · 04-14-2009, 12:06 PM

Hello stephen1000,

When the data the copied "Data" worksheet, do you want to over write any previous data or add the new data below the old data?

**stephen1000** · 04-14-2009, 02:54 PM

Originally Posted by Leith Ross

Hello stephen1000,

When the data the copied "Data" worksheet, do you want to over write any previous data or add the new data below the old data?

Hi Leith,

Its a rolling database so if 4 rows are filled on the form sheet those 4 rows are added to the bottom of the data already stored

if two are filled so on and so on

cheers

**Leith Ross** · 04-14-2009, 05:09 PM

Hello stephen1000,

I updated your macro to copy the information from the "Form" sheet to the next available row on the "Data" sheet.

Please Login or Register  to view this content.

**stephen1000** · 04-14-2009, 05:34 PM

Hi Leith

Thanks for that

I have changed it around so the data is cleared when saved,

but it seems to be pulling the lines across to the data sheet as well?

please look at the data sheet A201

thanks

**Leith Ross** · 04-14-2009, 05:44 PM

Hello stephen1000,

This version only copies the values - no formatting.

Please Login or Register  to view this content.

**stephen1000** · 04-14-2009, 06:52 PM

Leith

YOU ROCK!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

thanks for that

stephen

macro for saving multiple rows of data to new sheet

LinkBack

Thread Tools

Rate This Thread

Display

macro for saving multiple rows of data to new sheet

Re: macro for saving multiple rows of data to new sheet

Re: macro for saving multiple rows of data to new sheet

Re: macro for saving multiple rows of data to new sheet

Re: macro for saving multiple rows of data to new sheet

Re: macro for saving multiple rows of data to new sheet

Re: macro for saving multiple rows of data to new sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions