Results 1 to 35 of 35

Macro to Get Data from CSV then fill new sheet

Threaded View

elgato74 Macro to Get Data from CSV... 02-28-2024, 02:52 PM
Danny44 Re: Macro to Get Data from... 02-28-2024, 06:12 PM
AliGW Re: Macro to Get Data from... 02-29-2024, 07:23 AM
jindon Re: Macro to Get Data from... 02-28-2024, 10:32 PM
elgato74 Re: Macro to Get Data from... 02-29-2024, 07:19 AM
jindon Re: Macro to Get Data from... 02-29-2024, 09:02 AM
elgato74 Re: Macro to Get Data from... 02-29-2024, 09:19 AM
jindon Re: Macro to Get Data from... 02-29-2024, 09:23 AM
elgato74 Re: Macro to Get Data from... 02-29-2024, 09:24 AM
jindon Re: Macro to Get Data from... 02-29-2024, 09:31 AM
elgato74 Re: Macro to Get Data from... 02-29-2024, 09:35 AM
jindon Re: Macro to Get Data from... 02-29-2024, 09:44 AM
elgato74 Re: Macro to Get Data from... 02-29-2024, 11:35 AM
jindon Re: Macro to Get Data from... 02-29-2024, 08:46 PM
elgato74 Re: Macro to Get Data from... 03-01-2024, 09:02 AM
jindon Re: Macro to Get Data from... 03-01-2024, 09:27 AM
elgato74 Re: Macro to Get Data from... 03-01-2024, 09:49 AM
jindon Re: Macro to Get Data from... 03-01-2024, 09:55 AM
elgato74 Re: Macro to Get Data from... 03-01-2024, 09:58 AM
jindon Re: Macro to Get Data from... 03-01-2024, 10:15 AM
elgato74 Re: Macro to Get Data from... 03-01-2024, 10:21 AM
elgato74 Re: Macro to Get Data from... 03-01-2024, 10:18 AM
jindon Re: Macro to Get Data from... 03-01-2024, 10:19 AM
jindon Re: Macro to Get Data from... 03-01-2024, 10:33 AM
elgato74 Re: Macro to Get Data from... 03-01-2024, 10:39 AM
jindon Re: Macro to Get Data from... 03-01-2024, 10:45 AM
elgato74 Re: Macro to Get Data from... 03-01-2024, 11:13 AM
jindon Re: Macro to Get Data from... 03-01-2024, 11:23 AM
elgato74 Re: Macro to Get Data from... 04-10-2024, 07:31 AM
jindon Re: Macro to Get Data from... 04-10-2024, 08:14 AM
elgato74 Re: Macro to Get Data from... 04-10-2024, 08:21 AM
jindon Re: Macro to Get Data from... 04-10-2024, 08:32 AM
elgato74 Re: Macro to Get Data from... 04-10-2024, 08:49 AM
jindon Re: Macro to Get Data from... 04-10-2024, 08:54 AM
elgato74 Re: Macro to Get Data from... 04-10-2024, 02:09 PM
  1. #1
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Germany
    MS-Off Ver
    365
    Posts
    580

    Macro to Get Data from CSV then fill new sheet

    Dear all,

    The task is to come up with a macro that gets data from a CSV file on my desktop and then fills the data into an XLSM Sheet.

    I have attached both files to this thread.

    After data is loaded, the macro should map the data in the following scheme and fill the sheet accordingly:

    Column A in AG
    C in D
    E in AH
    F in A
    G in F
    I in I
    J in G
    K in E
    L in J
    M in M
    O in P

    Please note

    - that the CSV file has leading Zeros in Column "I" and in "L"
    - the header row in the XLSM file must not be changed

    Once that is completed, the macro should save the sheet as a new csv file to my desktop.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by elgato74; 02-28-2024 at 03:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to fill cells from Sheet 1 to Sheet 2 if match
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2023, 07:55 AM
  2. [SOLVED] Fill Sheet-2 Values Based on Sheet-1 (Kind of Vlookup but need a macro)
    By NametobeRenamed in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-31-2023, 03:30 PM
  3. Macro to fill the data into Summary sheet basis of different scenarios from Data sheet
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2016, 11:48 AM
  4. Macro to fill 3 columns in one sheet with data from 3 cells in another sheet
    By programct in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2013, 02:44 PM
  5. look up on sheet 1 match data sheet 2 and fill in cell on first sheet
    By treborharris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-28-2013, 01:01 PM
  6. Replies: 1
    Last Post: 07-30-2012, 02:35 PM
  7. As user fills out data sheet, then fill out a results sheet based on data sheet entry
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2012, 03:57 PM

Bookmarks

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