move

I have a large spread sheet where some values down load to the wrong column. To fix this I am looking for a macro that can look in Column H and where it finds Balance Forward look in the same row at column J and if there is a value move that to column K. Columns L and M will have values in...

Hello I have a problem. I would like to select various cells in one column and then move them to the next column in the same row. The size of the spreadsheet will change with each use. Example: the words Balance Forward Appear in cells I11, I23, I34, I36, I42. and so on. They need to be in...

Hello, I've been using this site for awhile now and it's been very helpful. Thanks. In most cases, I could find what I need or at least find something close enough that I could modify it to work. I've tried the same approach this round, with no luck. My excel document has 2 sheets that I'm...

Hi I can anyone help please i have 2 worksheet, worksheet 1 has all patients names in column A2 - A22 and address in B2 -B22. In column C I have a checkbox alongside each name/address. What I want to do is tick the checkbox and the name and address of the person on that row will move to...

At the moment, all my code is stored in two sheets and I want organise my code a little better by moving some of it into modules. I don't know how to move it to modules and have it still work, for instance, have the command button still run the code when it is clicked. How do I do this?

Hi, I am trying to move text up in a range when there is empty rows above or in between. I thought I had got it to work but I just found out a big problem, it clears and copies the wrong rows. Does anyone of you experts think you could help me out with this problem? Here is an example of the...

Is there a way, like creating a template, that will default to"do not move or size" shapes"?

I am trying to find the coresponding code that goes along with the clock in and clock out times. I have tried everything and cannot find a solution. Please help. For example< I need the times between 5:45 Am and 5:59 Am to correspond with code 2. The formula I have used is...

Need help in automating the formulas the reference row needs to move by 18 everytime. Could someone please help Thanks

Need help in automating the formulas the reference row needs to move by 18 everytime. Could someone please help Thanks

Hi, I like to move cells around the sheet in my work, to do so, you have to select border of the cell, only then you can move the whole cell. My question: is it possible to enable either through settings or VBA - ability to move cells by selecting any place inside the cell, not only the corner...

I’m on week 1 and I have a formula in cell A1, is there a way when I open up the spreadsheet next week (week 2) that the formula will move to cell A2 by itself? I’m not sure if this is even possible in the excel world but thought I’d ask. Thanks for any help.

Hi there, I hope this message finds you all well and in finc spirits today ;-) I'm trying to set up some macro buttons (ie a shape with a macro assigned to it) at the top of an Excel worksheet. This 'top' are ten rows which are 'Grouped' and typically collapsed when using the worksheet (i...

Hi Everyone, Working on a Table with define names im having this error: Run Time Error 1004 - Application-defined or object-defined error. im trying to do a simple record: go to the first cell(1,1) with ctrl+home shortcut , then move 2 cells to right, then ctrl+down arrow to the last cell...

Hello, I want to move the entire row when I have 100% complete in "F" cell to new sheet deleting the old. Sheet name "ActionItem" move to sheet "Completed" I would also like to keep original formatting but it isn't necessary. <tbody> a b c d e f g h request from priority assigned due status...

I have 1700 hundred record some are debit and some are credit I need to move credit value in debit column with negative sign as value

Hi, please help. My original table is: Row <tbody> 1 Title 1 2 Description1 3 Title 2 4 Description 2 5 Title 3 6 Description 3 </tbody> I need the following result: <tbody> A B C Title1 Title 2 Title 3 Description 1 Description 2 Description3 </tbody> I appreciate your...

I wrote this to force exit without saving anything. Works fine if it is in the active workbook but when I move it to my Personal.xls it does not work. On the intended workbook. Any ideas? Sub Quit() Application.DisplayAlerts = False ThisWorkbook.Saved = True Application.Quit End Sub

I'm trying to use VBA (novice!) to update a range of data, and I need to find the end of that range and then paste in new data. I'm currently selecting cell A1, moving to the bottom of that range, then trying to move one more cell down to get out of the filled-in area. Here's my code...

To simplify here is what I'm trying to do From this: To this: Move inventory 1 to 5 to the next month and ensure that leftovers is as close as possible to 0 but not go negative. The inventory Qty is treated as a whole and can't be combined Previous month's inventory takes priority and it can...