+ Reply to Thread
Results 1 to 1 of 1

How to enter rows of data accross multiple sheets and keep the formulas intact?

  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    Tennessee
    MS-Off Ver
    Office 365
    Posts
    7

    How to enter rows of data accross multiple sheets and keep the formulas intact?

    I work for a restaurant group that has recently started putting all employee's tips on paychecks. I made a basic spreadsheet to track all these tips because our Point of Sale cannot properly distribute tipout. My Excel knowledge is pretty basic, but some of the restaurant managers can barely enter data in the workbook without messing something up.

    The challenge I'm facing is when we hire a new employee and need to add them to the workbook, or when we separate an employee and need to remove them from the workbook.

    In the attached workbook, I have 3 spreadsheets that have employee data. "Week 1" is the first week of the pay period, "Week 2" is the second, and the "Payroll Total" sheet that is used to calculate their total paycheck. Week 1 and 2 are grouped by the position they work while the Payroll Total is simply alphabetical by last name.

    Is there a way to enter a new employee on Week 1 and have that row automatically input into Week 2 as well as the proper row in Payroll Total?

    Any help would be greatly appreciated. Thanks.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help - Look up Values accross multiple sheets
    By tims123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2013, 05:15 PM
  2. Help keeping data intact even when adding rows across multiple sheets
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2013, 09:20 AM
  3. Adding columns and/or rows while keeping formulas intact
    By KINNEY0201 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-24-2010, 06:11 PM
  4. inserting new rows in a spreadsheet and keep formulas intact
    By laddyboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2008, 02:27 PM
  5. Merge multiple rows with <alt-Enter> intact
    By RobertCo in forum Excel General
    Replies: 5
    Last Post: 12-14-2006, 03:02 AM

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