move

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...

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...

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.

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...

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

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...

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

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 ...

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...

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 ...

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...

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...

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...

Sir I have to move the file from one place to another i need the vba to do this i will put the location of that file in the vba code where it is located and where we have to move i will put that in the vba code so plz guide

Hi, i really need some help. I had many folder to move :) I want to move all inside files inside folder a to folder b *No overwrite of file with same filename as whole *delete empty folder <tbody> From Folder (Col A) Move to Folder (Col B) \\abc\folder1\ \\abc\Main1\ \\abc\folder2\...

I have an IF statement pulling date onto Sheet 1 (=IF('Sheet 2'!$E$4=H15,'Sheet2'!$C$4,False). However, I have some numbers in the E column that are identical, while the respective values in row C are different. Is there a way to tell excel to move onto the next instance of the number in column...

<colgroup><col><col></colgroup><tbody> Hi, I want to move left blue colored files to rightly mentioned red colored folder in all below cases. File name Folder name C:\Users\LENOVO\Desktop\New folder C:\Users\LENOVO\Desktop\New folder\CSC21251 CSC212512016120120161231.emd CSC21251...

Any ideas how to stop toggle buttons from moving every time i open my spreadsheet. I have a few of them. I have grouped them, set them to don't move or resize but they still do it. Many Thanks

I'm not a whiz at Excel and I asked a friend to write me a macro so I can press a button that moves the previous weeks worth of cells to a sperate tab and then another button so I can move them back to the main tab if need be. All that works fine until I decided to add conditional formatting to...

Hello everyone! I am having trouble getting to move an entire table from one sheet to another. I found this code from Jerry Sullivan: Sub ToggleTableHiddenSheet() Const sHomeSheet = "Sheet1" Dim sMoveToSheet As String With Range("Table1[#All]") If .Parent.Name =...