move

  1. 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 -...
  2. 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...
  3. 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
  4. 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...
  5. 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
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. A

    number to word

    HI is it possible to see the number/amount in words if we hover mouse cursor on a number in excel as a comment not in any cell, it will show as a comment box and when we move the cursor from the number the comment should vanish thanks dinesh saha 9932022569
  13. J

    Copy and pasting ranges with VBA

    Hello all! I don't have any sample data to upload at the moment but the question is fairly straightforward I believe. I put a table below to help visualize what I'm looking for. I have one worksheet with many ranges of the same size and I need a way to move one range to another range with a...
  14. L

    picture hide the text behind

    Hi I inserted a picture in a sheet. I moved the picture over a table. After that I can not see the contents of some cells. Can I put the picture in the background and move the text in front, like in Word? Thank you very much
  15. S

    Move dataset to new column when descriptor appears

    Hi, I'm trying to move a dataset into a new set of columns every time a descriptor appears. More specifically, if you look at linked images, I would like to move the corresponding dataset to new columns every time the word "particle" appears. Linked image #1 ...
  16. M

    Moving Files from folders less than specific size

    Hi All, I'm after a program that will loop through all folders and files in a directory regardless of what file type they are that are less than a specific size lets say 15GB and move them to a folder that it creates on the desktop called the less than 15gb and the date and then go through the...
  17. TAPS_MikeDion

    VBA 2011 for Mac (ver 14.0) - Screwed up userform scroll bars

    Hello everyone, Is there something I'm doing wrong with trying to add scroll bars to my userform? As per the title, I'm using VBA for Mac 2011 and I can't seem to get the scroll bars to work. I can only double-click them to get them to move. There aren't even arrows to click on. What the ...
  18. A

    Move certain data from one sheet to another

    My experience in Macros/VBA is pretty limited but I am slowly trying to get my head around it. I need some help finding a solution or code to help automate a part of a spread sheet which I will try and explain and hopefully someone can explain it to me. I have a excel workbook with two sheets...
  19. H

    Move multiple files by vba

    my files are located in C:\Users\WolfieeeStyle\Desktop\Files i have to move 4 to 5 files(it can be more than this) from here C:\Users\WolfieeeStyle\Desktop\Files to C:\Users\WolfieeeStyle\Desktop condition-check wheather my files are located in C:\Users\WolfieeeStyle\Desktop\Files if yes then...
  20. L

    Can't cut/paste, move or delete columns or rows

    I don't know what happened but all the sudden today I can't cut/paste or move any rows, columns on any of my spreadsheets. It was fine Friday. To my knowledge there's been no system update on my machine (it's my work laptop). I feel like there's an easy fix. Help!!! I have a ton of stuff to get...

Some videos you may like

This Week's Hot Topics

Top