database form data

  1. S

    Power Query: Merging Columns based on Article ID

    Good afternoon, I'm currently trying to merge two columns that have similar Article ID's, but one list has 17.000+ positions, the other only has 13.000+ positions. All 13.000 match the ID from the first list. Basically I want to add the new columns from a different database and match them with...
  2. L

    Populating A Master File - Managing Work Log Hours

    I am managing the volunteer hours for a volunteer fire department. In a nutshell, the member logs in to the website, fills out a form, and then at the end of the month, the admin exports the data. The website template provider doesn't allow us to change the export features, but we can change the...
  3. H

    Select Option from Web-based Database drop down list through VBA code into excel sheet

    Hello, I have an online database that I need to access data from. I've gotten as far as logging in and I'm at the page where I need to select the type of report I need. I would select if from a drop down list that contains 5 selections for different types of reports. I've tried using...
  4. L

    Macro to Copy Cell Contents to new Cell Row

    I've seen several threads here for this function but haven't been able to successfully modify those codes to work in my situation. I have a form I created on Spreadsheet1 I named M635Frm used to enter data that will stored in a database format on SpreadSheet2 (Named M635Db). I viewd a couple...
  5. C

    Need help in database in excel

    I have a spreadsheet with following columns - User ID Age Height Body type Complexion Diet many other like this I want to create a database such that, For E.g. if someone selects age between 23 to 26 and height 5.6 to 5.9, body type as average, then it should pick all filtered data (as per...
  6. M

    Creating a form and storing information

    Hello! This challenge may be better handled in Access or a true database but the person making the request only uses Excel. 1. Create a form that will accept names, dates, and grades. 2. Store the information on a separate worksheet so that it's being accumulated and reports can be ran from...
  7. A

    Creating A Submission Form

    Hey All, I have pretty extensive Excel skills and decent VBA skills so coding/logic is not where my problem lies. What I am trying to do is have some sort of digital form whether it be a Word document, Excel sheet, or Adobe pdf. The form will be sent out, filled out, and sent back from various...

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
Back
Top