shift cells

Hi everyone, I need help with a VBA code to shift an existing table from right to left in Excel. I’ve attached two screenshots for reference: Screenshot 1: Shows the current layout, where the columns "Number", "Name", and "Salary" are in columns A, B, and C. Screenshot 2: Shows the desired...

Hello helpful people! I am trying to cut and paste the value of multiple ranges of cells shifting them 8 columns to the right. Essentially every month, I want the user to click a button and the previous month's results will automatically shift to the right so that the current month's results...

Hi Everyone, my probleme is that when when i shift cell up using a VBA button all the formula using that cell as to do calculation become #ref! because the ref have shifted up by one cell. The formula i use to delete and shift cell up: Range("B6").Delete (xlUp) Example : i want to delete the...

Hello everyone, I am working on a project employee capacity-sheet, with several projects and the capacity for each month. I want the percentages (D2:M4) shifted automatically when I, let's say, change the end date to 2023-05. How do I achieve this? Thank you so much in advance! :-)...

<colgroup><col><col><col><col><col></colgroup><tbody> Data looks as below want it as below May 05 2019 May 05 2019 Jun 17 2019 Aug 9 2019 a a e sg rs rs a dgh 1 1 45 1234 [+1] [+1] Jun 17 2019 e a 45 Aug 9 2019...

Hello, I'm fairly new to code but can usually problem solve my way to getting it to do what I need it to. I have been trying for days and have not had any success modifying scripts to get them work. HELP! This is what I'm trying to accomplish: 1. Copy "A4" and "B4" in sheet "DataEntry" 2...

Hi so I'd like some help with something I am currently working on. I need to delete all values that contain IA, IB, JC etc the cells will have "IA01" "IA02" etc I'd like to delete these values and move the cells up all using a formula if possible - although VBA/macro is also ok These are...

Hi Hoping someone could help me with the following. I need a macro that will check all cells in Column A and if a colon is not present in the cell then shift the cell to the right. Before: <tbody> Column A Column B Column C 123 456 789 12:40 abc def Text ghi jkl </tbody> After...

My worksheet looks like this: <tbody> A B C D E F G H I J K L M N O P 7 Days Group Holdings SVN 13.59 13.59 13.5 13.54 -0.05 -0.37 57,657 13.6 8.1 ... ... 23.93 12.27 0-9 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U...

Hello friends, I need your help, once again! :) I shall give brief about my task, might give you a better understanding. I have a excel file with data over many sheets, etc. it's a server based automatic update workbook. and everyday, once a day the update takes place. and according to the...

I've got to change the format of this report so each new category gets its own row and the children entities appear on the next row down. It's hierarchial. Take a look at the before/after for what I'm trying to do. I'd appriciate a macro but if theres some other solution I'm missing let me know...

I have a list of data within column B. The data is all spread out out in column B. For example, B1 = IsEmpty B2 = ABC B3 = IsEmpty B4 = ABC I would like to run some VBA to basically wipe out all the blank cells for this column only, so that I am only left with cells that have data...

Two Terrible Scenarios (created by MRI Accounting Software output to Excel) occur I'm trying to fix: Scenario 1: Cell Contains Words and Letters and needs to "cut" letters and paste into column next to it, shifting as needed and leaving words. Before - A1: Net Rental Income 370,378 After -...