populate data

  1. J

    adding subquery in insert into

    "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...
  2. K

    Macro to vlookup multiple columns

    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...
  3. O

    Populate a Variable size range with changing constants

    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...
  4. T

    Urgent help!! Userform!! Wont populate!!!

    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...
  5. N

    How to Look Up an Excel Timestamp between Two Dates

    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...
  6. C

    How to Auto-populate in different sheets via keyword with a command button

    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...
  7. C

    How do I transfer information to another worksheet via command button and also sort that data numerically

    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...
  8. G

    Geology Logging and Sampling using Excel

    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...
  9. K

    Need help with formula and populating data into columns in separate sheet

    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...
  10. K

    Need formula for populating info to corresponding columns in separate sheet

    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...
  11. E

    Count If Month is Current Month

    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...
  12. Z

    Macro to populate weeks and rows on multiple sheets

    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...
  13. N

    Populate payee banking info into payment requisition form

    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...
  14. M

    Finding and inserting value from previous list.

    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...
  15. P

    From an Excel spreadsheet, using ActiveX command button to create a new workbook with data from current workbook.

    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 =...
  16. C

    Using VBA Userform to populate an excel spreadsheet,

    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...
  17. H

    Excel macro to get the product details based on criteria

    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...
  18. G

    Automatically input data from created database based on inputs.

    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...
  19. L

    Populating Column with Duplicates

    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...
  20. I

    VBA: Populate Userform checkboxes based on Cells Values

    okay, so I constructed a loop to populate a range of cells based on the value of checkboxes in a userform. Now I'm trying to do the reverse. have the userform on activation mark the checkboxes according to the range it filled prior. Here is the working loop from form to worksheet: Dim k As...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top