populate data

Hi Guys, I am trying to do the following: 1. I have a Master sheet, in this sheet I need to enter some details regarding patients, once I click Save entry, I want three things to happen. a) Generate a new sheet called as the patient name and I want to see all the patient information b) Populate...

"insert into temp_cost(RecordID,ClassID, Classtype, ClassName, TypeOrder, CreateDate) values('" & strRecordID &"','"& strClassID &"','"& strClassType & "', '" & strClassName & "', '" & strTypeorder & "', '" & strCreateDate & "')" This code works, but I am trying to add a subquery to auto...

Hi, I need to populate almost 10 columns with information from another excel sheet. We usually do it using vlookup. Can we use a macro and automate it. SO that I just click once and all the columns gets populates. Table A where the information needs to be populated <tbody> IP Location Metal...

Below is an excerpt from a workbook I am attempting to build. I have been trying to automate the population of the correct range of rows in column F based on data input into columns B, C and D. The data in this example is manually entered to demonstrate my desired results. Knowing each row...

NOTE: I POSTED THIS A COUPLE WEEKS AGO, GOT SOME HELP BUT ULTIMATELY DID NOT GET IT WORKING. AND NOW ALONG WITH THE ISSUES BELOW, MANY OF THE SHEETS OR BEING "HIDDEN" WHEN ATTEMPTING TO GET THE USERFORM WORKING. QUICK BACKSTORY: Our line of work requires us to do a lot of documentation, the...

Hi All, I have a spreadsheet that will eventually contain a lot of data and I want to be able to use formulas and data validation to populate that data onto another sheet by date. I can't use the filter tool in my case. On the sheet with all the data column A has a timestamp formula...

Hello all. I am an architect and I am trying to develop a code in excel for organizing our projects. So far I have a workbook with two tabs. Sheet1 is called "Entry", Sheet2 is called "NumericalOrder", Sheet3 is called "Alphabetical Order", and Sheet 4 is called "Civil". The headers on the...

Hello all. I am an architect and I am trying to develop a code in excel for organizing our projects. So far I have a workbook with two tabs. Sheet1 is called "Entry" and Sheet2 is called "NumericalOrder". The headers on the Entry and Numerical Order sheets is Project #, Project Name...

Hello Excellers, I am actually a Geologist and just familiar with the basic functioning of Excel. My fieldwork involves logging of drill cores at regular depth intervals followed by further division of those depth intervals to less than 1 meter or so to be sent to the lab for chemical analyses...

I'm not even sure where to begin with this but here is what I was asked to do: <tbody> "When a date is entered in column F(Contract Award/NTP Date) and the "Execution/Monitoring in Construction" is selected from the drop down list in column D(Project Lifecycle Phase), the Column...

I'm not even sure where to begin with this but here is what I was asked to do: <colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody> "When a date is entered in column F and the "Execution/Monitoring in Construction" is selected from the drop down list in column D, the...

Here is the Issue I have 3 Pie Charts, they are populated from a spreadsheet that has a Status page (pie charts are located there), and the status page is updated from 3 additional sheets from the spreadsheet. I need the pie charts to only update with the current month data only, the sums of...

Good Day, I am currently working in a workbook which uses a macro. The Macro uses information input on a Data Sheet and a Template to populate any number of spreadsheets based on the data populated on the Data Sheet. This is very useful; however, I am also in need of modifying or using a new...

Hello, I am trying to automate our payment requisition form by creating another worksheet with payee banking information and will aim to have the worksheet populate on the payment requisition form in the same workbook. I currently have eight items of information for each payee, such as client...

To start off I am new on this forum and self admittedly not very good with excel formulas. I appreciate in advance your help. I will try to give as much information and background as I can. The basis of my needs is to be able to find in a list of names, a duplicate name from previous list and...

I have created a pricing estimator in Excel. I want to be able to click on an ActiveX command button to generate a new Workbook and name it the client's name in Cell F3. On the same worksheet as the ActiveX command button, I have an estimate. Column A = Quantity Column B = Item Column C =...

Hi, I'm new to VBA so only have a basic understanding so please bear with me. I need some help with this: I'm trying to set up a VBA userform that will input information directly into a spread sheet. All the user has to do is click the userform, add the info and click populate, and the entered...

Hi Team, Can anyone assist me with macro code in order to get the required output. I have unique product criteria, the moment I select this product in the below example as Product Z, I need get another 3 (fixed common products) products should populate in the below row wth respective of qtys...

I have a database consisting of 3 columns and endless rows. I would like to be able to input data into column a and column b and have column c automatically filled in. For example I have been tracking the cost of groceries at multiple stores so that I can better forcast my expeditures. I shop...

Hey guys, I'm given a number of student id's and I need to extract the classes they're taking from a classes file. I can't seem to find anywhere how to populate cells based upon this criteria. In the classes file, you would be correct in assuming the majority of students have more than one class...