data collection

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top