Excel spradsheet automation help

D

deepika

there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3
layouts ar ethere for all 3 sheets.
the first sheet is used as input and based on certain fields/columns in the
first sheet i need to populate entries in the second and 3 rd sheet.
teh main purpose is taht based on the first sheet the 2 and 3 sheet should
be automatically filled. wat kind of formula / macro should i be using ..
im new to this and jsut know to create macro. CAn anybody help
 
C

CLR

ON either Sheet 2 or Sheet 3, you can put this formula in any cell and it
will return whatever value is in cell A1 on sheet 1.

=Sheet1!A1

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel spreadsheet 1
Is there a way to force out other editors when Excel 2003 is inautomation mode? 3
Complex formula help , please. 13
Problem in adding macro to ribbon through Add-in 7
Excel VBA help: Text file formatting 19
How to copy data from a "parent sheet" to another 19
HOW ?Excel chart auto insert /populate a code based on date 6
Evaluating 3 Excel Sheets 1

Top