+ Reply to Thread
Results 1 to 2 of 2

Macro to Fill in Username

  1. #1
    Registered User
    Join Date
    01-04-2021
    Location
    Missouri
    MS-Off Ver
    Office 365
    Posts
    1

    Macro to Fill in Username

    Good Morning, I'm new to working with Macros with Excel and looking for some help.

    I've attached a spreadsheet with what I'm working on. I'm trying to figure out how to do some productivity numbers at a warehouse. Every time an employee scan and picks a case it creates a row on the spreadsheet but it only shows there "User" name on the first scan. I get this file for everyday. I want to set up something so it automatically fills out the user name for each row. I've highlighted the spaces I wanted to populate in yellow and the username in green. but I'm not sure how to have excel put in the user name automatically. This report was created so it can be printed out so it has header information which I've highlighted in orange. I don't need anything in the orange to do anything.

    I don't know if there is a way to set it up so it looks for a list of user names and if the cell underneath it is empty it puts in the user. I've got another worksheet in there with a list of usernames.
    Attached Files Attached Files
    Last edited by JRCooper5; 01-04-2021 at 11:45 AM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Macro to Fill in Username

    .
    Best practice would be to post your existing macro code used for the scanning process.

    Post all of your existing code for review.

+ 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. Fill textbox with the username in another userform when login
    By Shunwen82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2015, 08:31 AM
  2. Automatically fill next cell with date and username when a checkbox is selected
    By EHowarth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2015, 06:14 AM
  3. problems with macro to automatically fill the username and macro to unhide sheets
    By djtosh1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2015, 07:14 AM
  4. VBA will open page but I can't get username and passwork blank to fill in
    By Motu040602 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2014, 10:42 AM
  5. [SOLVED] Username and Password Form - Show Username in Sheet
    By ryan180 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2013, 07:06 PM
  6. Auto Fill Cell w/Username & Date if Value added
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2009, 10:27 AM
  7. Username macro
    By littleoichoy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2009, 08:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1