+ Reply to Thread
Results 1 to 10 of 10

Insert multiple rows in filtered data

  1. #1
    Registered User
    Join Date
    07-06-2019
    Location
    Wellington, New Zealand
    MS-Off Ver
    Office 365 Home & Office 365 ProPlus
    Posts
    12

    Insert multiple rows in filtered data

    Is it possible to insert multiple rows in filtered data?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Insert multiple rows in filtered data

    Yes. Have you tried to do this and what results did you receive.

    BTW: Please update your Excel version. You have posted a Windows Release of Win 10 which does not help us to help you.
    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
    07-06-2019
    Location
    Wellington, New Zealand
    MS-Off Ver
    Office 365 Home & Office 365 ProPlus
    Posts
    12

    Re: Insert multiple rows in filtered data

    Hi alansidman - sorry still new to forums but want to learn more about Excel - Couldn't find the Excel Version, we are on Office 365 Home & Office 365 ProPlus, do I need to add the year ?, which I don't know where to find, since we're on a subscription plan, so I assume we're on the latest.
    About adding multiple rows in filtered data - I was only able to add one row at a time by selecting the row and insert one row - See attached example Attachment 632100
    Could I add 3 rows above row 93 instead of just 1? Thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Insert multiple rows in filtered data

    Your office version is fine now - there is no version date with the subscription model because it is always up-to-date.

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    07-06-2019
    Location
    Wellington, New Zealand
    MS-Off Ver
    Office 365 Home & Office 365 ProPlus
    Posts
    12

    Re: Insert multiple rows in filtered data

    Thanks Ali, here's some mock data of the result I'm after.
    Attached Files Attached Files

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Insert multiple rows in filtered data

    Could be done with a macro (I recorded this, but it works wherever you place the cursor):

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-06-2019
    Location
    Wellington, New Zealand
    MS-Off Ver
    Office 365 Home & Office 365 ProPlus
    Posts
    12

    Re: Insert multiple rows in filtered data

    Thank you AliGW for your quick reply. I'm not an expert in macros but have pasted your code and ran into the attached error.
    Attached Files Attached Files
    Last edited by CYO; 07-13-2019 at 04:30 AM.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Insert multiple rows in filtered data

    What were you doing EXACTLY when the error happened? Did you have the row selected?

  9. #9
    Registered User
    Join Date
    07-06-2019
    Location
    Wellington, New Zealand
    MS-Off Ver
    Office 365 Home & Office 365 ProPlus
    Posts
    12

    Re: Insert multiple rows in filtered data

    Awesome it worked when I selected only one row, but not multiples rows at once, but that will do thank you! Already a few steps lesser than what I used to do

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Insert multiple rows in filtered data

    No problem - glad to help!

    I am sure an expert could reduce the code to one line or enhance it in the way you want.

+ 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. Insert multiple rows to when data is different in columns
    By jak73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2014, 07:41 PM
  2. Insert 3 rows in multiple filtered row
    By afiqsabri in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2014, 12:24 AM
  3. Copy data into multiple rows using macros and insert zero
    By DeepthiBas9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2014, 07:35 AM
  4. [SOLVED] Insert Multiple Rows Based Off Number in Cell and Copy Data From Above New Rows
    By tstell1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 04:15 PM
  5. Need Macro to insert a Specific number of Rows (in Filtered list)
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2012, 08:05 PM
  6. [SOLVED] how to insert multiple rows in excel 2010 between data
    By Drum in forum Excel General
    Replies: 2
    Last Post: 05-18-2012, 03:51 PM
  7. Insert numbers before data in multiple rows
    By Brandy in forum Excel General
    Replies: 4
    Last Post: 01-07-2009, 11:57 AM

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