data collection

  1. I

    Data Entry Forms and Worksheet Restrictions

    I am trying to create a data entry form that can be sent to employees via an excel link that will only allow them to see the form and what they are entering on the form, not the rest of the worksheet. Is this possible? If not with Excel alone, is this possible with Excel and another program?
  2. M

    Button or Form? Ask User to Paste the Raw Data?

    Hi all: New here - please be gentle! I am looking to create a form that you can click and will ask you to paste the data.. the data would be in CSV format or not but when you get the data it will put it in Column A then that will be use for vlookup later. I just need a head start on how do I...
  3. G

    VBA Userform Time Picker

    I am not very good at this but I'm trying to make a Time Picker using VBA userform. I have 2 spin buttons, 'spinbutton1' to control hours and 'spinbutton2' for minutes, and textbox named 'tbtime' I am having trouble because I need it to show as 24hr time, I also need it to not change date...
  4. A

    Collect 500 rows of data daily from 200 users

    Hi, I need your creativity! Problem: I work in a support team in a company where we receive approximately 500 orders per day from approximately 200 users in the company. Currently, these 200 users will either call or e-mail to place their orders. We use approximately 2.5 full time people to...
  5. F

    Creating a data log of changing data?

    This is really over my head. I googled and I am finding ways to run a timer, but my VBA skills are just too weak to make sense of it. Nevertheless, I am desperate to add this functionality to my spreadsheet. Hoping you amazing folks can help! Thx! I have live data streaming into my excel sheet...
  6. E

    VBA for data validation on massive input sheet

    Hello. I'm sure that many of you will know that Excel's data-validation tool from the ribbon is easily overridden by copying and pasting a cell from elsewhere. I'm aware that VBA can be used for validations but I don't know how to do it. I found one macro online that seemed to work but very...
  7. tycasey17

    Collecting Information based on dates

    I would like assistance on how to be able to collect the information from this table for the dates between 1-1-2013 thru 1-7-2013 (basically a 1 week time period) to sum up the man hours, for each mechanic. <tbody> MECHANIC DATE MAN HOURS WORK Smith, John 1-1-2013 5 Trans Doe, Jane...
  8. E

    Data Collection & Summing

    I need to collect and sum manhours for an activity for a monthly period of time. Cells A1 thru O1 contain 15 different start dates occurring during a single month for one activity. The activity takes 4 consecutive days to complete and requires 7 manhours on day 1, 6 manhours on day 2, 4...
  9. J

    Macro to collect survey responses into single sheet

    Hi, I have created a survey template and have people respond by typing into designated cells in their copy of the survey. All surveys are single-sheet, but they may span several pages. I have stored the survey files that I received back in the same folder. Is there a macro that will help me do...
  10. C

    Is this the right approach:- vba to check value in each cell in a range is as expected

    hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I would be grateful if you could give me your view to whether this is the right approach:-<o:p></o:p> <o:p></o:p> <o:p></o:p> There is a current process where many people send in data...
  11. B

    Copying data

    I've been trying for a while to write a code that will copy the data between two workbooks (lets say A and B) but will only copy columns A2:T2 and then down the used range. I am unsure as how to state that in the code. Does anyone have any examples of code they got to work for copying between...
  12. N

    Macro for retreiving info from many workbooks

    Hi please can somebody help. (I am using Microsoft Excel 2002) I have 1000's of workbooks (with identicle layouts, different data). I am wanting to summarise all this data in one Master Summary workbook. Can someone please help with the Macro to do this. In more detail, All my workbooks...
  13. A

    email and pring macro

    I've checked out lots of posts and haven't found exactly what I'm looking for. Here's what I'm trying to do. I have a worksheet that sales people will be printing and giving out to clients. I want to be able to disable all other ways to print except from a button, but before the print I want to...
  14. C

    Scheduling Data Collection

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I am using a macro to collect data on manufacturing processes every 5 minutes, Our Company has 3 shifts. On week days I can start the macro when I leave to collect data through 2<SUP>nd</SUP> and...

Some videos you may like

This Week's Hot Topics

Top