Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am putting together a quality assurance sheet for a contact center.
The sheet works fine right now to score calls, etc., but the next step is to save the data somewhere. So, is there a relatively simple way to save the data into rows on another sheet? In more detail, what I'm hoping to do is add a "save" button to the bottom of the scoring sheet that does the following: Copies (for example) cells c1, c2, c3, c4, c5, d7, e7 and e11 to a second sheet and puts that data in rows so that row 1 would look like this: Cell A1 contains the data from sheet1, cell c1. Cell B1 contains the data from seeht 1 cell c2 and so on. Then after copying the data over, the save button would reset sheet 1. I understand that this will probably involve VB or something, and don;t expect you to do it for me, but if you know of examples online, links to those examples would be fantastic. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Carry data from sheet to sheet automatically | Excel Discussion (Misc queries) | |||
data from sheet to sheet automatically | Excel Discussion (Misc queries) | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
can entered data in sheet 1 be automatically pasted in sheet 2 | Excel Discussion (Misc queries) |