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
|