Related:
- How to copy data from one sheet to another
- Transfer data from one excel worksheet to another automatically - Guide
- Google sheet right to left - Guide
- Little alchemy cheat sheet - Guide
- How to screenshot excel sheet - Guide
- Tmobile data check - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 7, 2011 at 11:02 PM
May 7, 2011 at 11:02 PM
suppose the main data in sheet1
you have three more sheets called region1,region2,region3 all of which has column heading as in sheet1' and the names of the stores in that region
select sheet region1 and select B2
pressing shift key click tab or region2 and region3
now type the formula
=VLOOKUP($A2,Sheet1!$A$1:$D$100,COLUMN(B$1),0)
copy B2 to the right and down for four or five rows.
now click shee1.
you see region1, region2 and region3
now change some data in sheet 1 and see whether it is reflected in region sheets.
this is manual
if you want a macro post back
note:
if you want to enter same data or same formula in the same cell over multiple sheets you select one sheet and select that particular cell and pressing shift key select other sheets. all the sheets will be chosen. now type whatever you want, the data (or formula) is entered in all the sheets. make some experiments in a blank file.
you have three more sheets called region1,region2,region3 all of which has column heading as in sheet1' and the names of the stores in that region
select sheet region1 and select B2
pressing shift key click tab or region2 and region3
now type the formula
=VLOOKUP($A2,Sheet1!$A$1:$D$100,COLUMN(B$1),0)
copy B2 to the right and down for four or five rows.
now click shee1.
you see region1, region2 and region3
now change some data in sheet 1 and see whether it is reflected in region sheets.
this is manual
if you want a macro post back
note:
if you want to enter same data or same formula in the same cell over multiple sheets you select one sheet and select that particular cell and pressing shift key select other sheets. all the sheets will be chosen. now type whatever you want, the data (or formula) is entered in all the sheets. make some experiments in a blank file.
May 8, 2011 at 01:11 PM