Results 1 to 6 of 6

Macro to: Delete specific columns (and to create csv)

Threaded View

maamon Macro to: Delete specific... 03-14-2020, 01:31 PM
Eastw00d Re: Macro to: Delete specific... 03-14-2020, 03:11 PM
maamon Re: Macro to: Delete specific... 03-14-2020, 05:04 PM
Eastw00d Re: Macro to: Delete specific... 03-14-2020, 03:41 PM
maamon Re: Macro to: Delete specific... 03-14-2020, 05:14 PM
Eastw00d Re: Macro to: Delete specific... 03-15-2020, 06:30 AM
  1. #1
    Registered User
    Join Date
    01-26-2020
    Location
    Warsaw, Poland
    MS-Off Ver
    365
    Posts
    28

    Macro to: Delete specific columns (and to create csv)

    Hi Guys,

    I need a macro which would delete columns based on specific criteria after clicking a button. I'm attaching an example file containing 3 tabs:
    raw export - this is an export of a database, this is pasted manually to a tab;
    working - which is a tab to be presented to a country consultant to decide if a listed company is going to participate in a survey;
    to import - will be imported back to the database after review.

    So in the tab WORKING in this example I need to remove all columns which are not specific for POLAND (POL). What need to be deleted depends on a field H1. Columns marked 'ALL' can never be deleted. And second thing is to remove all values after last not empty row (well empty rows have ZEROS here because of linking).

    In the tab TO IMPORT I also need to remove columns, which are not specific, but I cannot change names of headers, or add any additional row for mapping. Maybe there could be some mapping tab added or another row in "WORKING" tab to do this. Or maybe there could be another button to change "Y" values into "1" directly from "WORKING" and create CSV file? What is marked in green in the tab "TO IMPORT" is linking and without this it will not be possible to update database.

    If you have any ideas how to combine all this ideas into something smart, I would be grateful.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to delete rows and columns
    By siroco79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2013, 07:37 AM
  2. [SOLVED] Delete Multiple Columns with specific column headings using a Macro.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-30-2013, 07:28 PM
  3. [SOLVED] Help with macro or script to delete specific columns from worksheet
    By damjerm in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-23-2013, 01:40 PM
  4. Need a macro to format data and delete columns and create new column
    By aacod in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2013, 12:15 PM
  5. Need a macro to format data and delete columns and create new column
    By aacod in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2013, 12:14 PM
  6. Macro to delete certain rows and create columns
    By excel77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2010, 10:06 AM
  7. Replies: 5
    Last Post: 08-16-2006, 02:05 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