+ Reply to Thread
Results 1 to 7 of 7

Add new data to correct column

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Add new data to correct column

    I am trying to automatically add new data that has been entered into the correct column on another sheet. I have attached sample file that shows the solution sought a bit better. Thanks for any assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Add new data to correct column

    I am unable to post my solution :(
    Last edited by shukla.ankur281190; 09-23-2016 at 02:36 AM.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Add new data to correct column

    Checking it now
    Last edited by BRISBANEBOB; 09-23-2016 at 02:48 AM.

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Add new data to correct column

    Quote Originally Posted by BRISBANEBOB View Post
    That didn't really help that much...

    Check the attached file in post #2 as I am trying to post my solution post here the web page is not allowing me to do.

  5. #5
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Add new data to correct column

    Thanks Shukla. I've got it and I'm working on it now. Thanks for your assistance.

  6. #6
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Add new data to correct column

    That is unbelievably good! First time I've ever seen Aggregate (which looks quite useful). Thanks, mate, much appreciated.

  7. #7
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Add new data to correct column

    Glad it helps you please add reputation...

+ 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. [SOLVED] Data not lining up in the correct column
    By javaj in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-05-2015, 04:37 PM
  2. [SOLVED] enter data to correct column using userform
    By tintin007 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-01-2014, 03:49 PM
  3. Data not moving to correct row/column
    By JBlunt918 in forum Excel General
    Replies: 3
    Last Post: 07-10-2013, 02:38 PM
  4. Replies: 4
    Last Post: 06-05-2013, 09:13 AM
  5. Replies: 4
    Last Post: 03-21-2013, 11:35 AM
  6. Transposing data to different sheets in the correct column & row
    By Navin Agrawal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 09:17 AM
  7. Replies: 1
    Last Post: 04-21-2011, 04:36 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