Code for transferring data

Ashwin Reddy - Aug 23, 2016 at 02:41 PM
 Blocked Profile - Aug 23, 2016 at 04:36 PM
i Have an excel workbook with different sheets. In sheet 1, i have date picker, where i select date and enter all the data for that particular date. The other sheets have section to which that data entered in sheet one had to be transferred based on the date.
In other words, excel should search for the date selected in sheet 1 and transfer the data to the other sheets.

Thank you

1 reply

Blocked Profile
Aug 23, 2016 at 04:36 PM
You should be using a database (access) not a spreadsheet. What you are describing, is record keeping, not financial operations.