move

Hi, Can you please tell me the macro used to add 10 columns at K starting at row 50? Basically, I want to move all data from k50 and below, over 10 columns to the right, without moving the data above k50. Thanks!

I am trying to code this correctly. Please Help I am working with data sets taking up 10 rows, no merged cells and all cells the same height, each job list takes up 10 rows. after selecting 10 rows making up 1 job, I want to cut them and insert them 10 rows up (moving the job above down to...

Hi all, I am looking for some help, I am trying to create code that will move a column of data to another column location on the same worksheet based on the value found in row 1 On my report I have the following headers in row 1 plus many more however these are the important ones Supplier (A)...

Hi I have the macro shown below and I need to add a few things to it but dont know where to start. What it is when I have done the auto filter for each unique criteria on both sheets I need it to compare the totals between the two sheets and if both balance then OK nothing needs doing, If not...

Hi All, Previously I had a little help online including in this forum on finding how to write a macro to move data from one workbook to another, This time its the same idea but from one worksheet to another 2 worksheet based on a True or false. From Raw Data file: I want to move all with True...

Hi I have seen lots of discussion on VBA moving rows to another worksheet based on a value eg "done" which have worked for me. However what I am currently trying to do is move rows based on date, each row has a due date and once this date has passed I would like to move the row to a different...

Hello All, I cant remember.... Isn't there a way to move a column with formulas over to the left of another column without your formulas changing? I know this is a basic short cut....But am having trouble remembering it...

I have Excel 16 on MacBook I need to be able to search 2 columns and if there is a match to move the corresponding value in a third column to a fourth column Example If column A6 has a value equal to column B8 then I want to move the value in column C8 to column D8

Hi, I'm trying to move data from one spreadsheet to another (instead of using a copy and paste code which uses too much memory). I'm trying to reduce a 70MB file down to something more manageable and think removing the copy and paste function will help a lot. In workbook "Book1" I'm trying to...

I want to move a file to another folder. Using this code, i got error "File already open" Name "c:\sour\file.txt" As "c:\dest\file.txt Is there a workaround to move the file even when it is opened ?

If I use Shift+F10 for any selected FormControl/ActiveXControl/Shape, the correct context menu appears. But if I right click the object, I get a menu that reads : Move Here Copy Here Cancel Anyone know how to fix this?

sorry if this has been covered. I'm trying to move rows that an inventory item has sold to my sold sheet in the same workbook if I enter the account number in column Q. I want the account number to be able to move with it when it's entered.

Hi all, Kindly advice me for a VBA code so that to move the duplicate numbers from credit side which is col. "J" to col "I". Note that the code should move the second number. I present below an extract of original data and expected result. Thank you all in advance Original data <colgroup><col...

Hello All, Is there way to configure MS Access so that the cursor moves to the next record (below) after I enter value (using bar code reader) in a record? We are entering a number of values in a form using bar code reader. After entering every value we have to manually move cursor to the next...

New to VBA and trying to piece together a macro but the table part is causing me problems. I have multiple "3 or 4 column" tables on a worksheet. I want to move a cell value by Double Clicking the cell on one table, then click anywhere on another table to move that cell value to that table...

Hi Guys, I need ideas on how to move sheets from 1 db based on a criteria in 1 sheet to a new wb. Below is my code. The challenge with the below code is it is not sustainable, if there's a new condition, I would copy over the whole code to create another If and Then command. Thanks! Option...

I use excel 2010 for a work order worksheet. One the work order is complete ( the work complete in say J3) I want to move that entire line to worksheet 1 (from work orders). So if J3 says "complete" then move entire line to worksheet 1. Please help. Thank you, Justine

I have a simple horizontal bar graph. The X-Axis title currently sits on the X-Axis at the top of the graph (above the horizontal bars). How do I move the X-Axis title to the bottom of the graph along the x-axis (below the horizontal bars)? I know I can physically drag it, but is there an...

Hi everyone, not sure if this can be done but what I need is this. I have a sheet with 800 rows I have a scroll bar and I need to move it to the right position on the page. so I need a macro that can count 100 rows from the top and move the scroll bar so the top of the bar is in row 100...

Hi Everyone, I want to set up a VBa scroll bar to move a value up and down rows in a column? In Column Y I have the word "Start" now lets say its in cell Y25 I'd like to have a VBA scroll bar next to it and as I scroll up and down have the word "Start" move up and down the Column. can this be...