data into sequential rows without overwriting the data in prior rows - help please.

[newby11]

Hi Everyone: I am extremely new to programming (about 5 days experience) and I'm having some problems. (understatement)
I have not taken any programming courses before, so I'm on a steep learning curve.

If there is someone who would give me a bit of help, I would be most appreciative. (thank you)

This is my situation:

I have a set of 7 numbers(or 7 data sets if you wish) (located in 7 cells) all side by side - such as A1:G1. (hypothetical cell location but essentially accurate)
I want to copy the data from cells A1:G1 and move them to another location (let's say) A20:G20. ( I can do this.)

What I can't do is the following;

I want to copy the data from cells A20:G20 let's say to cells (A30:G30 - where I suppose I am creating a table. (7 cells (columns) wide x possibly 500 rows (deep/down).
The data (all numbers) exists in 7 sequential cells.
when the first set of data is written into cells A30:G30 - I then create a second set of data, which I want to locate into the next set of cells, which in this example would be A31:G31.
When this occurs, I do not want to overwrite the data from cells A30:G30. ( I need to be able to view the data from prior entries)

Each day, there may be between (let's say) 100 to 500 7 cell row entries, and I need to be able to view all 100 or 200 lines of data. (on some days there may be up to 1000 lines of data -possibly)
In case I have not been specific enough - each data set of 7 values located in 7 cells is located in 7 cells(in 7 sequential columns) all on 1 row, but all placed on 1 row.

The best I can do so far is to have the data write into cells A30:G30 and have that exact data written to sequential cells (IE: A31:G31) and so on.
Whatever data is copied into A30:G30 - always is copied into Rows A31:G31 and down the page - the same data>
I believe that I need to somehow increment each cell by 1, something like cell(A30)+1 so that the data goes into subsequent cells, but nope - I can't make it happen.
I don't know how to move the data into subsequent cells and keep/maintain the prior data.

If anyone could/would lend a bit of help, ...thank you.

J.

[Tinbendr]

Here's an article about copying data from row 2 to end of data.

I think you should be able to adapt this code to your situation.

It's not clear how you can move the data from row 20 to 30, but not overwrite, when you state that there could be 100 lines daily. A spreadsheet with some sample data would go a long way to helping us understand what you're trying to accomplish. You can attach one by clicking the Go Advanced button, then scroll down to manage attachments

[newby11]

Good Morning Tinbendr: (or anyone else who may be able to help me - please)
Below: is my situation.
I was hoping NOT to have to write anything in VB, rather "is it possible?" to just write something/some excel code within the cells to do this?
1 2 3 4 5 6 7 <- Data input on these cells
(original data input here) A1:G7




1 2 3 4 5 6 7 <- copy data to another set of cells
(to view for another application) A7:G7


1 2 3 4 5 6 7 <- set #1 (I do not want to overwrite the numbers) A11:G11
11 12 13 14 15 16 17 <- set #2 A12:G12
21 43 45 56 67 76 32 <- set #3 A13:G13
<- Perhaps there could be
<- 200 to 1000 sets ( and so on down the page)
<- of numbers…

(It's possible that there could be 1000 rows (lines) of data)
(which I need to be able to view)

Thanks again for your help.
I do appreciate this.
J.

[XOR LX]

Hi.

Perhaps if you attach an actual workbook with an example or two and your expected results then it may be possible to help you.

Regards

[newdoverman]

Why not use the data entry form that is built into Excel. It is a button that you can install on the Quick Access Toolbar (QAT). Click on the QAT in the Title bar at the top right of Excel, choose More Commands, All Commands. Scroll down to Form and select it and click on add. This will add the form button to the QAT.

On your worksheet, enter column Headers in Row 31 for the columns that you will fill with values. Click on the cell just under the headers just entered, click on the new Form button in the QAT and a message will appear that the headers can't be found. Ignore that and continue on. A data entry form will be presented. Enter the values and click New Record. The records will be entered under your headings.