+ Reply to Thread
Page 4 of 4 FirstFirst ... 2 3 4
Results 46 to 48 of 48

Code to Pull Records From 2 Other Sheets

  1. #46
    Registered User
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    87

    Re: Code to Pull Records From 2 Other Sheets

    Hello BSB,

    I selected the 'Add New' which cleared and made ready for new entries which works fine. Then I started to add a new AFR 10010 in D4 and filled out the rest of the fields but when selecting 'Update Data' it didn't paste the data to the 'AFRsDB' but it does paste to the 'AFRsParts'. Though it will paste the same info there ('AFRsParts') as many times as the button is selected.


    One request also if possible would be to insert the AFR number in Parts Table when entering parts. I want to hide that column eventually.

    I appreciate it very much.
    Attached Files Attached Files
    Last edited by fredfarmer; 03-17-2019 at 06:45 PM.

  2. #47
    Registered User
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    87

    Re: Code to Pull Records From 2 Other Sheets

    Hello BSB,

    I was wondering if it's more logical to have one cell (D4) on the 'AFRsInput' sheet for the AFR #. It seems that it is prone to errors having the same value in multiple places.

    Could it still be a list and if the number isn't there prompt: "Would you like to add a new AFR?"

    What do you think?

    Also the 'Add New' is set to increment to the next number. Could this be open to allow the user to put a number that is not already in the list?

    Thanks so much again
    Last edited by fredfarmer; 03-19-2019 at 09:29 AM.

  3. #48
    Registered User
    Join Date
    03-12-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    87

    Re: Code to Pull Records From 2 Other Sheets

    please bump to front thank you

+ Reply to Thread
Page 4 of 4 FirstFirst ... 2 3 4

Thread Information

Users Browsing this Thread

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

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