Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RedHeadedMenace
 
Posts: n/a
Default populating from sheets -- and PLEASE don't tell me I need VB!

Stupid newbie question, Excel 2003:

I have a 2 sheet document. SOME of the info from Sheet 1 needs to appear on
Sheet 2.

For example, Sheet 1 Column G values need to be populated to Sheet 2 as
Column B, Column H needs to be Column D, etc.

Is there any way to automate this without having to write a VB script? I
know a macro could kind of do it, but I don't think it could take all the
parameters, since Sheet 1 is constanly being altered (i.e., new values,
etc.). Oh, and all rows are relational so that G3 value from Sheet 1 when it
goes to Sheet 2 B17 also has to have H3 from Sheet 1 go to D17. Essentially,
the command is: suck only these input values from Sheet 1 and pout them HERE
on Sheet 2.

It would be really nice if the formula could be set up not just as a page
function but as a workbook function (i.e, =SH1A3 (as in Sheet 1, cell A3),
but I haven't seen anything to suggest that this could be done, and my excel
guru friend says she's never done anything but C&P to move info.

Have tried to read VB programming instrux and eyes glaze at the gibberish.
Sorry, I am just a dumb girl trying to run Office, not a a techie who can
even begin to understand prog jargon.

respond please via NG OR email.

THX!!!!
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Red

You can "link" cells from one sheet to another so's what you enter on sheet1
will be entered in sheet2.

On sheet2 in column B at B1 enter =sheet1!G1

You can drag/copy down as far as you need.

When you enter something in sheet1G1 it will be entered in sheet2B1

Watch out if you sort column G on sheet1, sheet2 won't follow.

These are the basics of linking.


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 11:43:01 -0800, RedHeadedMenace
wrote:

Stupid newbie question, Excel 2003:

I have a 2 sheet document. SOME of the info from Sheet 1 needs to appear on
Sheet 2.

For example, Sheet 1 Column G values need to be populated to Sheet 2 as
Column B, Column H needs to be Column D, etc.

Is there any way to automate this without having to write a VB script? I
know a macro could kind of do it, but I don't think it could take all the
parameters, since Sheet 1 is constanly being altered (i.e., new values,
etc.). Oh, and all rows are relational so that G3 value from Sheet 1 when it
goes to Sheet 2 B17 also has to have H3 from Sheet 1 go to D17. Essentially,
the command is: suck only these input values from Sheet 1 and pout them HERE
on Sheet 2.

It would be really nice if the formula could be set up not just as a page
function but as a workbook function (i.e, =SH1A3 (as in Sheet 1, cell A3),
but I haven't seen anything to suggest that this could be done, and my excel
guru friend says she's never done anything but C&P to move info.

Have tried to read VB programming instrux and eyes glaze at the gibberish.
Sorry, I am just a dumb girl trying to run Office, not a a techie who can
even begin to understand prog jargon.

respond please via NG OR email.

THX!!!!


  #4   Report Post  
RedHeadedMenace
 
Posts: n/a
Default

Thanks to both of you!!! I am amazed I was so close to the answer in
postulating a formula!!!

I never could find this under any search in my Excel help or MSO KB online.

XOXOXO!


"Gord Dibben" wrote:

Red

You can "link" cells from one sheet to another so's what you enter on sheet1
will be entered in sheet2.

On sheet2 in column B at B1 enter =sheet1!G1

You can drag/copy down as far as you need.

When you enter something in sheet1G1 it will be entered in sheet2B1

Watch out if you sort column G on sheet1, sheet2 won't follow.

These are the basics of linking.


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 11:43:01 -0800, RedHeadedMenace
wrote:

Stupid newbie question, Excel 2003:

I have a 2 sheet document. SOME of the info from Sheet 1 needs to appear on
Sheet 2.

For example, Sheet 1 Column G values need to be populated to Sheet 2 as
Column B, Column H needs to be Column D, etc.

Is there any way to automate this without having to write a VB script? I
know a macro could kind of do it, but I don't think it could take all the
parameters, since Sheet 1 is constanly being altered (i.e., new values,
etc.). Oh, and all rows are relational so that G3 value from Sheet 1 when it
goes to Sheet 2 B17 also has to have H3 from Sheet 1 go to D17. Essentially,
the command is: suck only these input values from Sheet 1 and pout them HERE
on Sheet 2.

It would be really nice if the formula could be set up not just as a page
function but as a workbook function (i.e, =SH1A3 (as in Sheet 1, cell A3),
but I haven't seen anything to suggest that this could be done, and my excel
guru friend says she's never done anything but C&P to move info.

Have tried to read VB programming instrux and eyes glaze at the gibberish.
Sorry, I am just a dumb girl trying to run Office, not a a techie who can
even begin to understand prog jargon.

respond please via NG OR email.

THX!!!!



  #5   Report Post  
Don Guillett
 
Posts: n/a
Default

glad to help

--
Don Guillett
SalesAid Software

"RedHeadedMenace" wrote in
message ...
Thanks to both of you!!! I am amazed I was so close to the answer in
postulating a formula!!!

I never could find this under any search in my Excel help or MSO KB

online.

XOXOXO!


"Gord Dibben" wrote:

Red

You can "link" cells from one sheet to another so's what you enter on

sheet1
will be entered in sheet2.

On sheet2 in column B at B1 enter =sheet1!G1

You can drag/copy down as far as you need.

When you enter something in sheet1G1 it will be entered in sheet2B1

Watch out if you sort column G on sheet1, sheet2 won't follow.

These are the basics of linking.


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 11:43:01 -0800, RedHeadedMenace
wrote:

Stupid newbie question, Excel 2003:

I have a 2 sheet document. SOME of the info from Sheet 1 needs to

appear on
Sheet 2.

For example, Sheet 1 Column G values need to be populated to Sheet 2 as
Column B, Column H needs to be Column D, etc.

Is there any way to automate this without having to write a VB script?

I
know a macro could kind of do it, but I don't think it could take all

the
parameters, since Sheet 1 is constanly being altered (i.e., new values,
etc.). Oh, and all rows are relational so that G3 value from Sheet 1

when it
goes to Sheet 2 B17 also has to have H3 from Sheet 1 go to D17.

Essentially,
the command is: suck only these input values from Sheet 1 and pout

them HERE
on Sheet 2.

It would be really nice if the formula could be set up not just as a

page
function but as a workbook function (i.e, =SH1A3 (as in Sheet 1, cell

A3),
but I haven't seen anything to suggest that this could be done, and my

excel
guru friend says she's never done anything but C&P to move info.

Have tried to read VB programming instrux and eyes glaze at the

gibberish.
Sorry, I am just a dumb girl trying to run Office, not a a techie who

can
even begin to understand prog jargon.

respond please via NG OR email.

THX!!!!





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"