Results 1 to 16 of 16

Looking to share data across many sheets based on certain cell data in sheet 1

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    Halifax, NS
    MS-Off Ver
    2010
    Posts
    7

    Looking to share data across many sheets based on certain cell data in sheet 1

    Hi Guys, I have been looking all over the web for a working formula for the following. I feel I cannot be the first person to want to do something like this, or maybe its not possible.. Im not sure. Here is my requirement (I hope I am thorough enough):

    GOAL: To auto populate the MONTH sheets with the relevent MONTH clients.

    WORKBOOK1
    SHEET 1 = Clients
    SHEET 2 = JANUARY
    SHEET 3 = FEBRUARY
    ...etc

    CLIENTS
    Row A
    A2 - JAN
    B2 - Client Number (numberic)
    C2 - Client Name
    D2 - Client Location

    JANUARY
    A2 - if CLIENT A2 = JAN - I want to copy B2 from sheet 1 into A2 of Sheet 2

    I can actually do this.. but I have an additional requirement:

    JANUARY
    B2 Cell - If A2 = Client number, lookup client number in CLIENTS and get specific cells from the row that has the CLIENT NUMBER.

    The end goal would be (as an example), if row 22 had FEB in the A column.. then it would automatically go to the FEBRUARY sheet and so on with the remaining months of the year.

    Is that helpful so that you guys can be helpful?

    Thanks in advance!

    Dave
    Last edited by DaveWW2; 10-16-2017 at 11:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Assitance on AverageIf Formula
    By sfoxbox in forum Excel General
    Replies: 1
    Last Post: 06-17-2014, 11:13 AM
  2. [SOLVED] Pivot Table Assistance Needed
    By mistye525 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 07-29-2013, 02:05 PM
  3. Need assitance with a complicated lookup tool.
    By kaputcha in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2013, 07:37 PM
  4. Drop down Box Assitance
    By philjthommo in forum Excel General
    Replies: 4
    Last Post: 01-15-2013, 01:33 AM
  5. Assitance appreciate with project
    By yashica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2012, 03:23 PM
  6. Data Associat Assitance
    By adeelkhan007 in forum Excel General
    Replies: 3
    Last Post: 05-11-2011, 03:48 AM
  7. Assitance with excel formula and logic
    By lee2k60 in forum Excel General
    Replies: 1
    Last Post: 03-31-2011, 05:31 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