Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
storing and recalling account data
I have 2 different worksheets within the same workbook with account data in
them. Sheet1 has cell R2 that identifies them as C or F, Sheet2 in cell R2 always identifies them as L. What I need to do is have a macro in Sheet1 labeled "SAVE" and in Sheet3 it will store data from 36 different cells in columns A through AJ. A similar macro in Sheet2 will save this data in Sheet3 in the next empty row, in columns A through AO (41 cells), the first 36 are labeled the same for Sheet1 & Sheet2. Then I need another macro in Sheet1 & Sheet2 labeled "LOAD" and have the ability to retrieve the data in one row into the appropriate cell in Sheet1 or 2. I have column A in Sheet3 labeled as CFL. Any help is appreciated. Thanks! Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
account # entry needs to return the account description | Excel Worksheet Functions | |||
Recalling an array of data | Excel Discussion (Misc queries) | |||
Help with storing data | Excel Programming | |||
storing data | Excel Programming | |||
I need help with recalling information | Excel Discussion (Misc queries) |