+ Reply to Thread
Results 1 to 1 of 1

auto-copying text and data from one sheet to another stock take sheet

Hybrid View

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    1

    auto-copying text and data from one sheet to another stock take sheet

    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.
    Last edited by maverick688; 07-10-2013 at 07:09 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1