Results 1 to 3 of 3

Thread: Autamatically insert row when data is sorted on another sheet

  1. #1

    Question Autamatically insert row when data is sorted on another sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    OK here is my problem... (and I believe VBA is the only way to go)

    I'm extracting data from one main sheet to a couple of different sheets. That is already been done by a 'IFERROR' formula.

    My next problem is that if I add new client data on the main sheet (at the bottom), and sort it (by name/alphabetically), it adds the new details on the separate sheets but the sorting on those sheets is only done in column B (the name of client). I need it to add l row so that the data I capture on each sheet don't get mixed up...!?!? Only column B is shifted down so data in column C, D, E ... is opposite the wrong name...

    If i could explain more in detail: If add "BATMAN" with ID number and sort it on the main sheet... it gets added to the 'Personal Tax' sheet alphabetically. Batman is added after Arista on the ID sheet, but the data (only a 'x') I entered for Bernabe show in the BATMAN row.

    I only want to do a "sort data" on the main sheet and all other sheets should be sorted automatically. But the data that's entered on the separate sheet should always stay opposite the correct name... I put a 'x' to mark months/work complete on each client. That 'x' should always stay next to or in the same row as the client name.

    Hope this make sense.

    PLS HELP!!!
    Attached Files Attached Files

  2. #2

  3. #3

    Red face

    SORRY... did not know that! I'm new at the forum thing...

    I will make sure that if and when I do get an answer to my problem I will post it here.

Tags for this Thread

Posting Permissions

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