Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data of Sheet1 should gets autometically posted in Sheet2
Hi,
I have two sheets: Sheet1 Sheet2 In Sheet1 i have 12 coulmns. Out of which few are as mentioned below: 1. Drg No 2. Project Name 3. FH 4. FL 5. RD 6. FPI 7. QTY In Sheet2 i have the 10 clolums. The 7 Columns mentioned in Sheet1 are similar to the Shee2 Now I want that as soon as i enter the data in Sheet1 it should autometically gets posted in Sheet2. How to do it. I want a macro becoz the formula gets deleted by the users by mistake then i had to sit to rectify the entire format. pls help me in this regards Thanks in Advance. Regards Akash |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data of Sheet1 should gets autometically posted in Sheet2
If you have done it with formulas why dont you just lock the cells with the
formulas in. Change the properties of those cells to locked, unlock the rest of the sheet and protect the sheet using toolsprotectionworksheet -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Akash" wrote: Hi, I have two sheets: Sheet1 Sheet2 In Sheet1 i have 12 coulmns. Out of which few are as mentioned below: 1. Drg No 2. Project Name 3. FH 4. FL 5. RD 6. FPI 7. QTY In Sheet2 i have the 10 clolums. The 7 Columns mentioned in Sheet1 are similar to the Shee2 Now I want that as soon as i enter the data in Sheet1 it should autometically gets posted in Sheet2. How to do it. I want a macro becoz the formula gets deleted by the users by mistake then i had to sit to rectify the entire format. pls help me in this regards Thanks in Advance. Regards Akash |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data of Sheet1 should gets autometically posted in Sheet2
HI jOHN,
IF I LOCK THE CELL THEN NO ONE CAN USE FILTER OPTION. THATS Y I DONT WANT TO LOCK IT. THUS THE NEED OF THE MACRO IS REQUIRED. THANKS AKASH On Feb 23, 6:20 pm, john wrote: If you have done it with formulas why dont you just lock the cells with the formulas in. Change the properties of those cells to locked, unlock the rest of the sheet and protect the sheet using toolsprotectionworksheet -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Akash" wrote: Hi, I have two sheets: Sheet1 Sheet2 In Sheet1 i have 12 coulmns. Out of which few are as mentioned below: 1. Drg No 2. Project Name 3. FH 4. FL 5. RD 6. FPI 7. QTY In Sheet2 i have the 10 clolums. The 7 Columns mentioned in Sheet1 are similar to the Shee2 Now I want that as soon as i enter the data in Sheet1 it should autometically gets posted in Sheet2. How to do it. I want a macro becoz the formula gets deleted by the users by mistake then i had to sit to rectify the entire format. pls help me in this regards Thanks in Advance. Regards Akash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sheet1 data goes to sheet2 automaticaly ? | Excel Worksheet Functions | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
How To Retrieve Data from Sheet2 into Sheet1 | Excel Worksheet Functions | |||
Transfering data from sheet1 to sheet2 | Excel Programming | |||
Transfer data from sheet1 to sheet2 | Excel Programming |