Looking up data in different sheet
 

Hi Group,
Maybe another dumb question from a noob, but I would like to be
able to enter data from selected cells in another worksheet when I
enter on sheet1....I know I could go to the second worksheet, select
the cell where I want the data entered and insert =, go back to sheet
1 select the cell whose data I want entered, and press enter, etc,
etc.,....the question is: how would you go about writing a function,
or VBA, that would do it automatically as you type in data on sheet1,
without having to go to sheet2 and doing the = everytime??....as it is
now, I can only do one line at a time, then repeat the = process each
time to change the cell reference, which is a very slow process...I
know the answer is probably very simple, but I don't have the
knowledge or expertise to make it so...any help would be very greatly
appreciated, as it always is...
Ken

Looking up data in different sheet
 

Right click sheet tabview codeinsert this. You may want to restrict to a
certain range or column.

Private Sub Worksheet_Change(ByVal Target As Range)
Set ds = Sheets("sheet7")
lr = ds.Cells(Rows.Count, "a").End(xlUp).Row + 1
Target.Copy ds.Cells(lr, "a")
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken" wrote in message
oups.com...
Hi Group,
Maybe another dumb question from a noob, but I would like to be
able to enter data from selected cells in another worksheet when I
enter on sheet1....I know I could go to the second worksheet, select
the cell where I want the data entered and insert =, go back to sheet
1 select the cell whose data I want entered, and press enter, etc,
etc.,....the question is: how would you go about writing a function,
or VBA, that would do it automatically as you type in data on sheet1,
without having to go to sheet2 and doing the = everytime??....as it is
now, I can only do one line at a time, then repeat the = process each
time to change the cell reference, which is a very slow process...I
know the answer is probably very simple, but I don't have the
knowledge or expertise to make it so...any help would be very greatly
appreciated, as it always is...
Ken

Looking up data in different sheet
 

On Oct 16, 10:06 am, "Don Guillett" wrote:
Right click sheet tabview codeinsert this. You may want to restrict to a
certain range or column.

Private Sub Worksheet_Change(ByVal Target As Range)
Set ds = Sheets("sheet7")
lr = ds.Cells(Rows.Count, "a").End(xlUp).Row + 1
Target.Copy ds.Cells(lr, "a")
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ken" wrote in message

oups.com...



Hi Group,
Maybe another dumb question from a noob, but I would like to be
able to enter data from selected cells in another worksheet when I
enter on sheet1....I know I could go to the second worksheet, select
the cell where I want the data entered and insert =, go back to sheet
1 select the cell whose data I want entered, and press enter, etc,
etc.,....the question is: how would you go about writing a function,
or VBA, that would do it automatically as you type in data on sheet1,
without having to go to sheet2 and doing the = everytime??....as it is
now, I can only do one line at a time, then repeat the = process each
time to change the cell reference, which is a very slow process...I
know the answer is probably very simple, but I don't have the
knowledge or expertise to make it so...any help would be very greatly
appreciated, as it always is...
Ken- Hide quoted text -

- Show quoted text -

Hi Don,
Thank you for your quick response! You are right, I do need to
restrict to certain cols and ranges....what I have is a sheet named
JobLogEntry, columns A thru T, with data entered in all cells on a
particular line....I need to copy the data from Col A (selected line
cell), to a sheet named Shipping, cell B:3; Col H, JobLogEntry,
selected cell, to cell B:5, Shipping, etc, etc with only a total of 6
entries from the 20 entries on JobLogEntry to Shipping sheet...and
just by selecting a line that has already been filled out, the info
from that line would appear on Shipping sheet....would that be too
much to try to do?? Like I said, I do ask some dumb questions
sometimes! Thanks for any help because I do appreciate it!
Ken

Looking up data in different sheet
 

Pls top post as it is easier, for me, to read.
Certainly doable if I understood what you want. Send a workbook to the
address below, if desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken" wrote in message
oups.com...
On Oct 16, 10:06 am, "Don Guillett" wrote:
Right click sheet tabview codeinsert this. You may want to restrict to
a
certain range or column.

Private Sub Worksheet_Change(ByVal Target As Range)
Set ds = Sheets("sheet7")
lr = ds.Cells(Rows.Count, "a").End(xlUp).Row + 1
Target.Copy ds.Cells(lr, "a")
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ken" wrote in message

oups.com...



Hi Group,
Maybe another dumb question from a noob, but I would like to be
able to enter data from selected cells in another worksheet when I
enter on sheet1....I know I could go to the second worksheet, select
the cell where I want the data entered and insert =, go back to sheet
1 select the cell whose data I want entered, and press enter, etc,
etc.,....the question is: how would you go about writing a function,
or VBA, that would do it automatically as you type in data on sheet1,
without having to go to sheet2 and doing the = everytime??....as it is
now, I can only do one line at a time, then repeat the = process each
time to change the cell reference, which is a very slow process...I
know the answer is probably very simple, but I don't have the
knowledge or expertise to make it so...any help would be very greatly
appreciated, as it always is...
Ken- Hide quoted text -

- Show quoted text -

Hi Don,
Thank you for your quick response! You are right, I do need to
restrict to certain cols and ranges....what I have is a sheet named
JobLogEntry, columns A thru T, with data entered in all cells on a
particular line....I need to copy the data from Col A (selected line
cell), to a sheet named Shipping, cell B:3; Col H, JobLogEntry,
selected cell, to cell B:5, Shipping, etc, etc with only a total of 6
entries from the 20 entries on JobLogEntry to Shipping sheet...and
just by selecting a line that has already been filled out, the info
from that line would appear on Shipping sheet....would that be too
much to try to do?? Like I said, I do ask some dumb questions
sometimes! Thanks for any help because I do appreciate it!
Ken

Looking up data in different sheet
 

Thanks, Don....I'll have to wait until I get home today to send a
file.....
Ken

On Oct 16, 11:00 am, "Don Guillett" wrote:
Pls top post as it is easier, for me, to read.
Certainly doable if I understood what you want. Send a workbook to the
address below, if desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ken" wrote in message

oups.com...



On Oct 16, 10:06 am, "Don Guillett" wrote:
Right click sheet tabview codeinsert this. You may want to restrict to
a
certain range or column.

Private Sub Worksheet_Change(ByVal Target As Range)
Set ds = Sheets("sheet7")
lr = ds.Cells(Rows.Count, "a").End(xlUp).Row + 1
Target.Copy ds.Cells(lr, "a")
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ken" wrote in message

groups.com...

Hi Group,
Maybe another dumb question from a noob, but I would like to be
able to enter data from selected cells in another worksheet when I
enter on sheet1....I know I could go to the second worksheet, select
the cell where I want the data entered and insert =, go back to sheet
1 select the cell whose data I want entered, and press enter, etc,
etc.,....the question is: how would you go about writing a function,
or VBA, that would do it automatically as you type in data on sheet1,
without having to go to sheet2 and doing the = everytime??....as it is
now, I can only do one line at a time, then repeat the = process each
time to change the cell reference, which is a very slow process...I
know the answer is probably very simple, but I don't have the
knowledge or expertise to make it so...any help would be very greatly
appreciated, as it always is...
Ken- Hide quoted text -

- Show quoted text -

Hi Don,
Thank you for your quick response! You are right, I do need to
restrict to certain cols and ranges....what I have is a sheet named
JobLogEntry, columns A thru T, with data entered in all cells on a
particular line....I need to copy the data from Col A (selected line
cell), to a sheet named Shipping, cell B:3; Col H, JobLogEntry,
selected cell, to cell B:5, Shipping, etc, etc with only a total of 6
entries from the 20 entries on JobLogEntry to Shipping sheet...and
just by selecting a line that has already been filled out, the info
from that line would appear on Shipping sheet....would that be too
much to try to do?? Like I said, I do ask some dumb questions
sometimes! Thanks for any help because I do appreciate it!
Ken- Hide quoted text -

- Show quoted text -