autopopulate

I need to copy/paste data into a table. From there, I need several columns to autopopulate with data. It works for simple absolute cell references i.e. Date = $O$1, Period = $O$2. However, when I try to use a formula I get an error and when I use other methods, they don't work. I have also tried...

Hi all! I'm racking my brain trying to figure out how to create what I thought was a simple spreadsheet for our company's contracted tow roster. We have 4 towing companies. Each time a vehicle is towed, the next company on the roster gets to tow the next vehicle and so on until all 4 have...

Hello, I have a spreadsheet on Sharepoint that I'm trying to make work. The purposes: To allow people from our building can add their name and birthdays. To have conditional formatting that automatically highlights all rows containing dates from the current month. To automatically populate...

I attached photos. I have a spreadsheet with multiple rows containing criteria to be met or unmet, and then columns pertaining to persons who have either met or unmet the criteria in the rows. What I would like to do is create a follow-up sheet that autopopulates any unmet items. The...

Hi, me again as you guys are really helpful. My next question that I can't seem to figure out is there a way to auto populate a sheet every time you add a new entry to a different sheet. This is the scenario: 5 sheets that I enter information into based on their filters. These sheets will have...

Hey folks, Have been searching the web and this forum for the last couple of days, but can't seem to find the answer to my specific question. I have a workbook that contains sheets named as follows - Data, Monthly Rolling, Sheet1, Sheet2...Sheet31 This workbook has been designed as a template...

Hi! I've been breaking my head trying to figure out and or find an answer on how to use a drop down list (of names) to fill down a column with the results. More detail. Lets say I have multiple sheets, each with a name, an a list of objects they own like this: And on another sheet, I have a...

Dear All, Please see below image, i have this job i need to do this manually everyday, if this can be automated it makes my life easier. I need macro that Populates usage end date in column T i hope i made instructions clear in Image, if anything more reuired please ask. Many Thanks for your...

Hi, I have a sticker template made up of 6 stickers that I'd like to copy the part number and its descripton from a second worksheet which includes list of part numbers. My challange is I want to auto populate sticker content on template with xls functions depending on number entry "for number...

I have a budget forecast workbook where I track my upcoming recurring bills along with all my transactions - be it cash, ATM, check, etc. This also includes any deposits. It is basically an electronic check register with a budget forecast function. There are three ways I gather/enter data: 1)...

Hello all, Does anyone know how to auto populate 1 row in excel (Workbook B) from information contained in 2 rows in a separate spreadsheet (workbook A)? Workbook A auto populates daily from a google doc form and workbook B is used for accounting (inputted manually). Do you know how to make...

I have a list of states and their counties. I'm looking for a method to choose a state from a dropdown and a column of their associated counties appears. Or, if the user types in the 2 letter state name and it auto populates the counties. I've played around with dropdowns and v/h lookups with...

Hello, I'm trying to figure out a Macro so that if I click (For Example) where it says "Double Click" it will copy the Student # in "A4"(in Red) to "C9" AND copy the Date in "C1" (in Green) to "C8". What I would like this to be able to do is, if i double click anywhere in "C2:E6" it will...

Hello all, This is one of my first posts, so please let me know if I'm not doing it correctly! I read the forum manual but still, I am human and I make mistakes.. My previous post was approved so I hope this one will be as well. So here it goes.. I have a userform which can copy specified...

HI Please can you help me i have a dropdown box in a userform and sheet14 i have a list of names, in the combobox named 'MTBox' i want this to autopopulate with the names in Sheet14, i have done the following code below that i found on the internet but this doesn't do anything, no errors or no...

Hi all, First time poster, long time user. Could somebody please help me with a macro that I would be far out of my depth with, and would help me save a plenty of writing long words in the future. I deal with a lot of plant samples from day to day and about 10,0000 need to be entered over the...

So this is my code: Dim src As Workbook Set src = Workbooks.Open("UMF_IR_ADM_<wbr style="font-family: arial, sans-serif; font-size: 12.8px;">SPARTACUS_1910 (Data as of 3-5-2018)") Worksheets("Executive").Range(<wbr>"D7").Value =...

Hi, I'm working on a workbook that has an index sheet on it the displays certain data elements based on data on the other worksheets. The issue I am running in to is that my table doesn't always update with all of the data consistently. It is like my For loop is ending early and I can't for...

When I export phone numbers from my contact data base it does not include the company name, it only contains the company abbreviation code. My thought is too match the abbreviations with the correct company names in sheet 2 and then insert a blank cell beside the abbreviation in sheet 1 and auto...

Hello, I am stuck on how to get this task done. I need to fill in the date automatically across the rest of the table by finding the last blank cell in the row, referencing the the cell before and filling the table to the last column. So in the example below F1 has a date and I need to fill...