Hi all I am fairly new to excel and have got around the basics but I want to create a basic stocktake work book in excel, and I just need to automatically copy columns from one sheet to another.
Each sheet on the workbook will relate to each month each month. the first 3 columns will be a description of stock and quantity's, so I want these to be the same on each sheet, even if I add items I want these to appear in each sheet hence I cant just copy and paste at the start.
Column 4 will be my starting quantity's, then the next 31 columns will be each day in which I will + or - numbers depending what I do with stock.
The next column will be the sum of the previous 32 columns, which I would like to automatically appear in column 4 of the next sheet.
so basically I want columns ABC to be the same on each sheet and column D to be the copy of the sum on the previous sheet.
I would appreciate any help or advice thanks.
Bookmarks