How to copy data from one sheet to another
Closed
Hello,
I am having a workbook. In sheet 1,m having store name in column A(A2:A9),in column B inventory for soap ranging B2:B9,in column C inventory for toothpaste ranging C2:C9,in column D inventory for Blades ranging D2:D9,this continues till column Z for different products. The stores mentioned in Col A comes under three regional heads,sheet2 contains 3 stores,sheet3 contains 2 stores and sheet 4 contains 3 stores.
Now i want that whenever the data in filled in sheet 1 for all stores as per products,the data automatically gets filled in respective sheet as per regional.
please help.
Shane
I am having a workbook. In sheet 1,m having store name in column A(A2:A9),in column B inventory for soap ranging B2:B9,in column C inventory for toothpaste ranging C2:C9,in column D inventory for Blades ranging D2:D9,this continues till column Z for different products. The stores mentioned in Col A comes under three regional heads,sheet2 contains 3 stores,sheet3 contains 2 stores and sheet 4 contains 3 stores.
Now i want that whenever the data in filled in sheet 1 for all stores as per products,the data automatically gets filled in respective sheet as per regional.
please help.
Shane
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
- Windows network commands cheat sheet - Guide
- Tmobile data check - Guide
- How to open excel sheet in notepad++ - 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