Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving data from a cell reference
Ok, I'm pretty sure this is not possible without running a macro but I
would love to be wrong. On one tab of a spreadsheet I have a form (a kind of a review) my Supervisors fill out on their employees (with mostly text). So let's say in cell B4 they are going to type a few sentences. I need for those sentences to be saved in another cell (say C5) on tab 2. The problem is that I want the form to be reused on a weekly basis, so new information will be typed into B4 on tab 1 every week over the information that was in their last week, but I want C5 on tab 2 to keep the information from the first week. To make it more complicated, I'd really like all of the information typed weekly in B4 to be Concatenated in the C5 cell on tab 2 so it keeps adding all of the notes from week to week in one cell. As it would likely be too much text throughout a year for one cell in excel to hold, I'd be fine with C5 on tab 2 holding week one's info, then cell C6 holding week two's info, C7 holding week three's info, and so on. Anyone know of a way to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sheet tab name to reference cell data | Excel Worksheet Functions | |||
Extract data from a cell reference | Excel Discussion (Misc queries) | |||
How do I save Excel info without saving the reference cells? | Excel Discussion (Misc queries) | |||
Data range reference in a cell | Charts and Charting in Excel | |||
Only Reference cell with data in them | Excel Worksheet Functions |