export excel data

  1. N

    Excel VBA multiple loops to output data to individual worksheets

    HI there I was wondering if someone can please help me. I have a services report that is generated every 6 months to capture whether service was delivered to the customer. I am trying to automate a manual process of outputting the results of undelivered service to the person's manager. I have...
  2. P

    VBA coding data import/export within Excel

    Dear Excel and VBA experts, As of recently I have compiled a piece of VBA coding and I could use some fine tuning in it. Perhaps some help can be provided here. I’ll further explain the case and my vision on how I would like to have it work. Case: I have one source spreadsheet in which there...
  3. D

    Help with VBA code to automate copying selection to new File

    Hi there, Im trying to write some code that selects a range of cells, different every time, that exports it to a new file with a predifined file name except voor the weeknumber. I first make a selection of the cells I want by filtering on weeknumber. After that I use to following code to...
  4. L

    Export Excel Form Data to Unique/Multiple Word Docs or PDF

    Hi, I have an excel document that is set up like a form: questions in row one and multiple candidates' answers to follow rows 2+. I'd like to extract each question/answer for each row into a unique PDF or word document so that each candidate has their own one-sheet. Is it possible to do this...
  5. O

    How can I export an Excel column to wordpad and save the file using VBA

    I have to confess I am a complete dummy when it comes to VB. I have an Excel spreadsheet which I would like to export to notepad. There are 4 sheets to the spreadsheet. The first takes input and runs some calculations and gives out figures. The following three take the information and translate...
  6. N

    export result of a macro to a text file

    Hi, i have written a macro in my workbook whose result is in sheet2. I have to export the result in a text file. it will be done through a .bat or .csv file. plz help!!
  7. A

    export and save data without leaving current workbook

    Hello VBA crusaders, I have a workbook with lots of calculations grouped by categories. I have a userform that directs users to initiate calculations in specific categories. Currently, the workbook parses the data and saves itself as a .xls. Instead, I would like to take just the sheets related...
  8. T

    DAO IgnoreNulls and copy value down a table

    I've got some data that I'm trying to dump into a database from excel. Everything is fine except I'm stuck on trying to get the average of some values into the database. Because sometimes I've got 2,3,4, or 5 values that I'm taking the average of and getting some statistical data on, I have...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...