+ Reply to Thread
Results 1 to 2 of 2

Formatting data for export

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Formatting data for export

    Hi, new member here!

    I am having some trouble with this.. I usually import data into Access and format/output it from there, but the user wants to do everything in Excel.

    On the attached spreadsheet, I have 2 tabs named "data" and "export"

    The data tab contains data that I want to ultimately have formatted for export.

    The export tab shows the format of the data.

    Could someone help me with the code to be able to put behind a button so that the data will be exported as .csv

    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    London, England
    MS-Off Ver
    Excel 2007

    Re: Formatting data for export

    1) Is that exactly as you want the export sheet to be formatted? Some dates are M/D/YYYY and some are DD/MM/YYYY. Is that right?

    2) Is the export sheet supposed to be an accurate summary of the data sheet? Because I can't for the life of me work out the methodology. For starters there is no account # 514000.01.10 listed on the data sheet. Or any 2010 dates.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1