Results 1 to 6 of 6

Fix template based on raw data sheet current and previous day

Threaded View

  1. 04-11-2020, 12:58 PM #1
    farrukh
    farrukh is offline
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Fix template based on raw data sheet current and previous day

    Hi Experts!
    I have a sheet named Template and Rawdata.
    There are two tables in Template sheet one based on previous date data and one belongs to current date data. requirements to fill the template sheet based three criteria matched from raw data sheet.
    1. Template sheet column F5 to column P5. with Rawdata sheet Column B
    2. Template sheet column F6 to column P6. with Rawdata sheet Column C
    3. Template sheet column G4. with Rawdata sheet Column A
    4. Then fill the data to Template sheet column F7 to column P7. with Rawdata sheet Column D ( For previous date data suppose in the template sheet the date is 10-Apr-2020 so fix the data for 9-Apr-2020 in the first table and in the second table data for current date which is 10-Apr-2020.

    The template sample is attached.
    Attached Files Attached Files
    Last edited by farrukh; 04-28-2020 at 02:30 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a Excel Sheet that auto populates based on data entered on a previous sheet
    By lewisjustind in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-27-2020, 11:39 AM
  2. [SOLVED] Finding the most current and previous current date based on multiple criteria
    By tkbuc in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-27-2016, 06:06 PM
  3. SUM IF FORMULA BASED ON CURRENT/PREVIOUS/NEXT Month
    By AK123 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-21-2016, 01:10 PM
  4. Creating a worksheet based on a previous template
    By troyaneitor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2015, 03:43 AM
  5. Need Help - Automatically generate template sheet based on previous data
    By gpukchar in forum Excel General
    Replies: 3
    Last Post: 04-17-2014, 12:21 PM
  6. [SOLVED] Reference of Previous sheet in current sheet cell.
    By ranjeet.bhagat57 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-25-2012, 11:37 AM
  7. Sum based on Current Week, Previous Weeks vs. Current Week Forward
    By cjsec9 in forum Excel General
    Replies: 4
    Last Post: 03-21-2011, 05:37 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1