| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy automatically from sheetx to sheet1
Every day I have to write data to different worksheets.
So there is written as example in sheet2 E80 value = 40.00 sheet3 E34 value = 25.50 sheet4 E78 value = 140.75 I would like to have this data automatically copied to sheet1 Columns B2 = sheet2 E80 Columns B3 = sheet3 E34 Columns B4 = sheet4 E78 By the next daily entry the row will increase And should copy Columns B2 = sheet2 E81 Columns B3 = sheet3 E35 Columns B4 = sheet4 E79 Has somebody an idea, how to do this with excel? Thanks in advance macbet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from file1 sheet1/file2 sheet1 last blank row | Excel Programming | |||
| How to have a total in sheet1 automatically plug in sheet2 | Excel Worksheet Functions | |||
| Difference among Module, SheetX, ThisWorkbook? | Excel Programming | |||
| How do I automatically (using a formula like =SHEET1!A$1) referen. | Excel Worksheet Functions | |||
| how can i call a sub() automatically when someone click on sheet1 | Excel Worksheet Functions | |||
Threaded Mode
