Good Day Everyone:
I am using Excel 2011.(Mac)
As (I hope) the example below shows, I am trying to take data (numbers) from 7 cells (such as A1:G1) and then moving that row of data to another location (lets say) A11:G11.
this process may occur 100 to 1000 times a day and I don't want to overwrite the previous cells of data, rather I want to move new data to the next row. (as in A11:G11 to A12:G12 to A100:G100 and so on)
Ultimately, at the end of a day, I could potentially view 100+ rows of data - to be analyzed,without overwriting any of the previous rows of data.
If possible, I do not want to work in VB: if possible, is there a way to work within the basic options of Excel itself?
I can move the data from A1:G1 to A11:G11, and to A12:G12, but I keep overwriting previous rows of data.
I have tried advancing the data from one cell (A11) let's say to (A12) by using (A11) +1 which does not work.
I have tried using if statements such that if +if(A11<>0, A11+1, A11) and similar, but I keep getting circular errors.
I have tried using if statements to reference cell A11 from (as an example) from A1, but that does not work.
I don't know how to tell excel that if there is data in a cell such as A11, then to place the data into the next cell - which would be A12.
OR better yet, how to tell excel that if there is data in A11, or A12 or A...1000 - then place that data into the NEXT cell.
Sorry, to be so stupid, but I'm really new to anything related to programming: but I am learning. :0)
If anyone could help, I would be appreciative.
Thanks everyone,
J.
(please see below)
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)
I am using Excel 2011.(Mac)
As (I hope) the example below shows, I am trying to take data (numbers) from 7 cells (such as A1:G1) and then moving that row of data to another location (lets say) A11:G11.
this process may occur 100 to 1000 times a day and I don't want to overwrite the previous cells of data, rather I want to move new data to the next row. (as in A11:G11 to A12:G12 to A100:G100 and so on)
Ultimately, at the end of a day, I could potentially view 100+ rows of data - to be analyzed,without overwriting any of the previous rows of data.
If possible, I do not want to work in VB: if possible, is there a way to work within the basic options of Excel itself?
I can move the data from A1:G1 to A11:G11, and to A12:G12, but I keep overwriting previous rows of data.
I have tried advancing the data from one cell (A11) let's say to (A12) by using (A11) +1 which does not work.
I have tried using if statements such that if +if(A11<>0, A11+1, A11) and similar, but I keep getting circular errors.
I have tried using if statements to reference cell A11 from (as an example) from A1, but that does not work.
I don't know how to tell excel that if there is data in a cell such as A11, then to place the data into the next cell - which would be A12.
OR better yet, how to tell excel that if there is data in A11, or A12 or A...1000 - then place that data into the NEXT cell.
Sorry, to be so stupid, but I'm really new to anything related to programming: but I am learning. :0)
If anyone could help, I would be appreciative.
Thanks everyone,
J.
(please see below)
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)