+ Reply to Thread
Results 1 to 3 of 3

Bulk Editing an Excel Sheet

  1. #1
    Registered User
    Join Date
    05-10-2017
    Location
    CA, USA
    MS-Off Ver
    2010
    Posts
    2

    Bulk Editing an Excel Sheet

    Hi all,

    I work for a ticket office and we are sending season ticket booklets in the next few months. We have an excel document with information for each ticket and need to do simple edits throughout the document.

    I was curious if it was possible to run a macro to edit a few things:

    1) I need to the clear contents (not delete the row) in columns C, D, E, F, and G if column A says "ticket".

    2) I need to insert a row at the bottom of each unique group of account numbers. I want to separate the last account number from the rest of the group (as seen in the images I attached).

    3) I would like to clear contents of rows M-S if they say the same thing and are next to each other. Like in the image I would like only the first name to be displayed, not the rest of the names underneath it.

    I understand these requests are quite specific and may be impossible, but any help would be much appreciated!

    Thanks for the help - AD
    Attached Images Attached Images
    Last edited by alexdegregori; 05-10-2017 at 07:43 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Bulk Editing an Excel Sheet

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-10-2017
    Location
    CA, USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Bulk Editing an Excel Sheet

    I wanna convert the document from Sheet 1 to Sheet 2. Thanks for heads up alansidman!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bulk Replace in Excel
    By sunnyujjawal in forum Excel General
    Replies: 4
    Last Post: 09-09-2014, 07:25 AM
  2. How to use a list in wone sheet to bulk search another
    By chrismyerwork in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2013, 04:26 AM
  3. [SOLVED] Bulk import. (Copy Data from one sheet to a main sheet with conditions)
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 12:24 AM
  4. [SOLVED] Changing Font of New entries / editing in excel sheet
    By azamathar in forum Excel General
    Replies: 4
    Last Post: 03-22-2013, 09:48 AM
  5. Replies: 2
    Last Post: 04-20-2006, 07:15 PM
  6. Editing fields in bulk
    By bhola-bhala in forum Excel General
    Replies: 2
    Last Post: 04-01-2006, 02:50 AM
  7. [SOLVED] How do I bulk change the sign (+ or -) in Excel
    By Steve in forum Excel General
    Replies: 2
    Last Post: 03-03-2006, 01:10 PM

Tags for this Thread

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