move

  1. 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...
  2. 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...
  3. J

    VBA SELECT THE FIRST CELLS THAT CONTAIN TEXT AND SHIFT THE VALUE BELOW IN THE RANGE

    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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. I

    NEED MACRO TO MOVE PDF INVOICES INTO DIVISION's MULTIPLE JOB#'s SUB-FOLDERS

    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...
  10. 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 -...
  11. T

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

    Hello guru's. I have always struggled with loop...do 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...
  12. 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
  13. 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...
  14. 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
  15. 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...
  16. 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...
  17. J

    macro to move list headers to columns

    Hello, If I download a list from exact it looks like below: <colgroup><col><col><col><col><col></colgroup><tbody> Subtotaal Akro Netherlands Inc. - 1682 19.0263 22-08-2019 19603880 60 - Inkoopboek 85 Plaatje zwart MDF 19.0282 11-09-2019 19604279 60 - Inkoopboek...
  18. K

    How do I take a total value and reduce the value of a cell and move to next until the total is met?

    It's difficult to describe, but could be considered something like a first in first out calculator. There must be an easier way to do this than manual subtraction. For this example the total inventory is 7500, I Would like to find how much was under 25, and if the total isn't met then move to...
  19. S

    VBA to copy sheets & rename to workbookname

    Hello Team, we have requirement, where in i have the excel files in the folder, where i need to move in to one workbook with sheets names as workbooks names in the folder.
  20. M

    VBA move selection to different sheet and insert based on selection

    Hi, I am working on below to move a selection of rows in sheet x given the string "Dead" to a next sheet (sheet y) and subsequently insert the amount of rows selected in that next sheet. Can anyone give an example how to show this in the code? Many thanks! Sub Moverow() Dim i As Long...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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 MrExcel.com.
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 "mrexcel.com".
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
Top