Heeeelp!!!
I've created a workbook for my expense claims, with various sheets in Excel for Mac 2011.
Spreadsheet 1 contains dates in column A, values in column Q & R and text in column S.
Screen Shot 2013-03-26 at 16.10.57.jpg
Spreadsheet 2-14 relate to each month and are named Jan - Dec. I need to create a formula to automatically pull the data entered in Spreadsheet 1 (columns A, Q, R and S) through to the corresponding month tabs in Sheets 2-14.
Screen Shot 2013-03-26 at 16.12.40.png
I hope there is a simple solution out there to help a novice.
Regards, Kevin
Bookmarks