1. T

    Move all data from selected rows, into the top most selected row.

    Hi All Another problem. Im seeking a function or macro to move all the data from a selected series of rows, into the top most row of the selected area. Example below. There are 12 rows of Romboutsia (84 to 95), and all rows will (/should) have 1 data point. Im looking to move all the data from...
  2. K

    Folder contents Empty

    Hi, I've written a VBA to copy files from a list of directory over to a specific folder. The code works fine and what I now need to do is add an IF statement for the VBA to move to the next folder when one folder is empty and copy any files in the next folder. Any codes that will allow the VBA...
  3. R

    Prevent changes to specific worksheet (VBA)

    Hi, I would like to disable the option to delete, move, copy or rename one specific worksheet in a workbook, regardless of the activated worksheet in the workbook. I cannot protect the workbook structure, because I want to still be able to delete other worksheets in this workbook without the use...
  4. Chris_010101

    VB Code for Moving Row

    I am working with an absence tracker and am currently using the below VB Code so when a drop-down list item returns "Closed", it copies the row across to the "Archived Absence" sheet. In the drop down, there is also a selection "LTS" for Long Term Sick people. When "LTS" is selected, I need it...
  5. J

    MOVE files from list found in folders/subfolders to same folder structure in another folder

    Hello, I have this script that move files from one folder to another based on a list in Excel. However, I have to go folder by folder to get the files. I wanted to modify the script such that it searches for the files from the main folder (that contains subfolders) and moves the respective...
  6. R

    Move (grouped) shape 5 columns to the left

    Hi all, I've got a grouped shape that will move based on the cell value entered in cell A1. Now I want this grouped shaped to always move 5 columns to the left. So when I enter value M8 in cell A1 VBA should automatically move the grouped shape to H8 (at least that is the upper left corner of...
  7. J


    Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...
  8. S

    Sort & Group Specific Cell Value

    Hi All, I would like to know how to achieve this condition programmatically. The main idea is to collect the same "attribute name" for each row for each grouping (column 2) Note: Grouping will be more than 1. like : Logi1, Logi2, Logi3, etc From this : To be like this (result): I had...
  9. D

    Macro move file to existing folder by name using filename first left7 digits with a space delimiter

    I'm looking for some help. I started trying to use excel for this project yesterday. I originally scripted a batch file to run this operation. The batch works in a small and limited environment. I tried the batch in a live folder and it was a complete failure with files being multiplied and...
  10. D

    Move Row from one worksheet to another based on cell value

    Firstly; I'm aware this has been asked loads but I just can't figure it out! I would like to move an row from my Worksheet "Action Log" to another worksheet "Closed Actions" when an "x" is input in the Complete column of my table. From what I understand I need to use VBA code but I've tried...
  11. A

    VBA equivalent without excel

    Hi Guys and Gals I have a problem that is out of my expertise I have some VBA working fine doing what it needs however the end goal is to copy a file form a network drive to a local drive, however, the local machine i need this on does have excel installed to fire the VBA form task scheduler...
  12. L

    Move Pivot Table to align with last row of other column

    I'm pretty new to using VBA, so please excuse my lack of knowledge or choice of words to describe my question Alright so I have a; -Pivot table 1 @ (A25:B29) -Pivot table 2 @ (A31:B34) -A regular table @ (D1:K50) ~ this table is constantly changing it's height (row count) could be K50 upto...
  13. I


    Hello Everyone, Good day I NEED MACRO TO MOVE PDF INVOICES INTO DIVISION MULTIPLE JOB#'s SUB-FOLDERS Everyone I’m new to EXCEL VBA I want to one VBA EXCEL MACRO that can move my PDF INVOICES (19361-11599-113) Files FROM SOURCE FOLDER (Y:\) into SHARED DESTINATION FOLDER (Z:\Billing...
  14. U

    VBA Copy, Move and Rename based on Cell Value

    Hi Guys, I have below data on a sheet with tab name "Data" Date NUM NAME TYPE DATE Subject Note 1 Note 2 10/1/2000 1 Ben Student - Math - - 10/1/2000 2 Ann Student - Science - - 10/1/2000 2 Cher Student - Math - - 11/1/2000 2 Joy Student - Science - - 11/1/2000 2 Sam Student -...
  15. T

    VBA Loop to find cell, move contents up, then clear old contents

    Hello guru's. I have always struggled with and I need to do more study on this theory. CONCEPT: code that allows me to loop through a worksheet and move Manager Name (find d.value) to 2 rows above Store Number (find c.value). The data sheet has various rows in-between c.value and...
  16. L

    conditional formatting - bar based on value

    Hi I created a conditional formatting based on the value of the cell excel would insert bar as below. The bar can move from left to right or right to left. My question can I create similar bar but move from bottom to top? is that possible? Thank you very much
  17. M

    finding the size of a Data File BEFORE importing to determine how long it will take before import

    I been searching for a while to determine how many records in a data set. This is so I can determine how long it will take to import. I would like to use this information in a progress bar. I have the progress bar going, I just need to plug values in the code to have the bar move. I can make...
  18. L

    Move Data If Sheets Match

    I need a formula to move data when column Matches I want to place a formula in a Sheet1 thats if Column D in Shet1 matches Column D in Sheet2 move the data from from shee2 for headers that match
  19. D

    VBA to bring columns in rows (except first column)

    Dear all, I'm struggling with a code to move columns values into rows, except the first column. Of course, it will be needed to add rows and populate the blanks in the first column. Probably, an example will make my exercise easier to understand: An important point is that the number of...
  20. A

    VBA to sort columns

    Hi All, I have multiple tabs I need to merge. I have been able to write the code to merge the into data into one spreadsheet, but sometimes that columns aren't a match. Is there a way I can sweep some VBA code over my workbook and sort the columns depending on the title, ideally going through...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back