User Profile
NotExcellentUser
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
VBA macro to copy & insert new row
I need to build a button-controlled macro to copy a few rows and insert them directly beneath the copied rows. The complicated part is that this needs to be able to repeat itself and move the selection below the previous repeated rows, and I need this action to be repeated on two sheets simultaneously. An example of my desired actions is: User has a workbook and the "Working Papers" sheet selected. The user selects the "New Rows" button for the first time. Rows 3:26 of the Working Papers sheet are copied and inserted beneath row 26 of the Working Papers sheet. Simultaneously, rows 2:26 of the "Backup" sheet are copied and inserted beneath row 26 of the Backup sheet. The user clicks the New Rows button again. Rows 27:50 of the Working Papers sheet are copied and inserted beneath row 50 of the Working Papers sheet. Simultaneously, rows 27:50 of the Backup sheet are copied and inserted beneath row 50 of the Backup sheet. This action may be repeated infinite times. My biggest confusion is how to ensure that the macro selects the last inserted rows and inserts the new rows beneath them. Any advice or guidance is appreciated. If there is a snippet of VBA code that accomplishes something like this would be happy to adapt it to my situation.526Views0likes1CommentConcatenating cells including date cell
Hi, I need a formula that copies an entered date into a specific format that can then be turned into text-field for further calculations. I've found if it's not a text field, whenever I reference it in further calculations it still turns into a date # like 43466 or something similar. Example: Entered text Static value Entered text End result 01/01/2019 T 00:00:00 2019-01-01T00:00:00 02/01/2019 T 00:00:00 2019-02-01T00:00:00 The 'Static value" column will always display a static value of a single letter. My closest attempts has been been: Adding a convert-to-text column for cell B1, then combining the (right) and (left) and (mid) parts of the cell. Excel throws this as an #VALUE error, and is still left in the date format Adding a convert-to-text cell for cell B1, then concatenating all the cells. But Excel still recognizes this cell as a date and the end result is 2019-01-01T0. Thanks in advance.988Views0likes4CommentsMatching Excel cells by column
Hi, I'm trying to do what I thought was a simple match, but it looks to be a little more complicated than I thought. I have two lists, each with their own column & respective ID #. For example, " [Microsoft] [24591245] ", using brackets to indicate cell. I want to match by the cell Microsoft, and I want the ID # to move with the associated cell. For example, I have a problem like this: A B C D Row 1: [Microsoft] [28275721] Row 7: [Microsoft] [9274395] Is it possible to automate putting these two next to each other, using "Microsoft" as the match, and having the ID follow the match? I may want another cell to follow the matching cell as well. I can use condition formatting duplicate values to find the value I want, but sometimes there's duplicate accounts. I would like those to move but if they don't have a matching value that's fine A B C D Row 1: [Microsoft] [28275721] Row 7: [Microsoft] [9274395] Row 60: [Microsoft] [9777772] Would look like A B C D Row 1: [Microsoft] [28275721] [Microsoft] [9274395] Row 2: [Microsoft] [9777772] Is this possible? Or even part of this possible? Thanks in advance1.4KViews0likes3CommentsHow to auto fill columns
Hi, I'm trying to simplify a list. I have two columns to work with in this scenario. I want Excel to autofill column B if column A says XXX. For example: if column B = London, I want column A = United Kingdom. I originally though I could use the vlookup function, but I believe that only allows the destination to be one cell. I want Excel to auto fill the next column over if the column next to it says a certain word. This seems like an easy, task, but I can't find a solution.1KViews0likes1Comment
Groups
Recent Blog Articles
No content to show