autopopulate

Hi there, I was trying to search through old forums and am really close to getting the answer I need but haven't quite found the perfect solution and am now turning here for help. I have column C in sheet 1 that currently populates only if somewhere in that row has the word "fail" or "hold"...

This is my first time posting a question, because I've always been able to find pre-existing answers in the past - thank you! My issue is hard to describe but I'm sure the solution is maddeningly simple: I have a spreadsheet with data in Column A, and a formula that references it in Column B...

I have an odd situation. One of my forms contains a VLOOKUP to a spreadsheet containing employee information. Enter the employee ID #, and the employee information is automatically populated. This is repeated about 10 times on the form, so you can enter the employee ID for up to 10 people...

Hi all, I am trying to create a formula that will automatically pull someone's name from a list depending on what code is listed under a specific day. The catch is the formula result has to be consider the day of the week and the time of day (AM or PM) that is selected in another cell. For...

Hi, I am looking for a way to populate a table in excel using another table that is populated manually and a table used for a lookup function. When the user enters a number (Priority Level) into the “summary table”, I would like excel to look at the corresponding skill (Tax, Bens etc) and...

Hello, have a farily large database of around 2000 people, sheet1 has all of their names and relevant details. Sheet 2 has data pulled on from a site. I would like the data from sheet 2 to auto populate the cells in Sheet 1. Also if the person does not exist in sheet1 to highlight the data it...

Hello All, I am trying to put together a spreadsheet that will be, pretty much automated, after importing data from another sheet. I am currently able to Sort the Data based of the import to other sheets based on the first column data which for this case is City. But the issue I have, is the...

This might be hard to explain, so bear with me. I have a data set that will automatically add information as it becomes available (Using the FRED add in to get economic data imported to excel), I have charts and graphs that will automatically update, however I need to make a table...

Hi there, I have taken on a project to automate a excel workbook. This worbook has multiple sheets. Each sheet is name the product name. Within that sheet it has the product name, a "Test Type" , a "Test Number", a "Status", and person who has looked at the product. I have created a userform...

Hello, New to the forum and had a quick question. I have a template that will be used many times. All the sheets are similar but each project will have a different number of sheets. Is there a way to populate the number of the last sheet on each sheet? My instance, I have a line that says...

Hi, I have been asked to create a spreadsheet for colleague in spite of being a relative novice! The problem is... I have two tables and I need for table1 to auto-populate according to table2's data. Table 2 is always the same except for one column which shows quantity. The idea will be that...

I have a column with certain values and corresponding values in the next column. I want to be able to autopopulate a 4th column with the 3rd column equispaced, as shown in this figure. I only put 17 rows to get the message across, but I would eventually have until 36 in column "cr3." could you...

Hi there, I've created a workbook that's intended to track construction costs per sqft for various scopes of a home build. Example : <tbody> Description Labour Materials Total Labour per sq.ft. Materials per sq.ft. Total General Requirements 2.00 2.00 0.23 0.23 Site Prep...

Hello, I'm very new to Excel (2010). I'm trying to figure out how to manage an inventory by keeping track of when an item is used, expired, or damaged and autopopulate that data on a second worksheet. For example: Column A is an order code ("offsuppencils") Column B is the item description...

Hey guys, I have seen a few other threads on this topic but not quite the same. I have an excel workbook which contains each month on a separate sheet. On each sheet it has each week and the hours I have spent at work per week. I have to fill out a timesheet eachweek and send to my work in...

Hi, hope somecan help. I am trying to autopopulate a master sheet in a workbook from multiple sheets in the same workbook. I have found this code online... can somehelp help explain what the code means as I am unsure how to edit it to make it relevant to my workbook. Please note, There are a...

Hi, I'm new to this and I hope I explain this the right way. I've managed to write two index arrays, one to find the first cell with a number and the last cell with a number in a row range and populate each of these to a cell: range is N5:AR5 1st cell with number populates to F5 per array in...

I'm working on a monthly timesheet template to autofill 8 hours on the days the employee works and 0 for their days off. On the bottom of the sheet it will have the total forcasted hours. I keep getting error messages when trying to write the formula/function. The layout is as follows...

Hello guys! I'm trying to automate my login information for a website. I can't seam to get the password field to autopopulate. My code so far is this: Set IE = CreateObject("InternetExplorer.application") IE.Visible = True IE.Navigate "XXXX" Do DoEvents Loop Until...

I have a query table that lists several ID numbers, and with those ID numbers comes several important dates, and other information. On a separate sheet, I would like a user to be able to plug in an ID number, which would then autopopulate any existing data. There are a few complications: 1)...