moved

Hey All, I am wondering if someone can help. Is there a way that if a file is copied or moved to a location other than the one i set in-bedded into the VBA it will pop up a message saying "Workbook should not be moved or copied from shared location". And then close? Reason is i have created a...

Hi I have a workbook and I have data all over the place and trying to standardise. Im looking to see if it can be done via macro. What im trying to do is listed below. In Column A where data states "FARE METHOD MARKER" I need all the data in the entire row moving across 2 columns . In...

I have a simple table with line numbers (1,2,3. . .x) appearing in Column A. Cell A1 is 1, Cell A2's formula is A1+1, Cell A3's formula is A2+1, and so on. This creates problems if anything gets moved. What is a good way to keep the line numbers sequential when a row gets added, deleted, or...

I am wondering if there is a unique ID similar to EntryID which remains unchanged with an email item regardless of if its moved to another folder. Does this exist?

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

Hello, I am to create a rank comparison formula. Can somone create a formula that tells me how many ranks a certain store has moved up or moved down? Example: Store has a decreased rank of 2 (from 1 -> 3). See below. <tbody> STORE NAME RANK 2018 STORE NAME RANK 2019 Store A 1 Store D 1...

Hello, I have a macro, activated by button click, that moves the entire row to another sheet ("Archive") if cell value in column F is "Finalised". Macro works fine. I want to add message after it finishes with information how many rows have been moved. The problem i am encountering is that it...

I have a listbox containing some files, i want a controltip to display each time a mouse is hovered on a file and when it is moved away, it should disappear.

I have a spreadsheet that is generated by Auto Cad Electrical. When I get the raw data I would like to run a macro from my personal workbook that will do the following: For each Cell in Column B that is empty, I would like to have the data in the adjacent cell in Column C be moved to Column B...

I am working on hotel housekeeping boards on Excel 2016. Here is an example: I would like all of the "due out" to be moved to a new sheet with the other info in the row. <tbody> 151 Due Out 350 152 Stayover 375 153 Due Out 325 </tbody>

Every since updating to Excel for Mac Version 16.18 (181014) recently, everytime I open Excel I receive an Alert saying "Sorry, we couldn't find Personal Macro Workbook. Is it possible it was moved, renamed or deleted?" I haven't moved, renamed or deleted it it. It has been in the same folder...

Hi all, I'm stacked with a formula in Excel or a way to get things sorted. Basically, I have some rows that need to be moved into columns an repeated x-times. Do you have any idea how can I obtain this? Thanks for your help. Daniele

ActiveWorkbook.SaveAs Filename:=Environ("UserProfile") & "\OneDrive\The Razz\DataBases\PLAYERS2018.xlsx", _ FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False ActiveWorkbook.Close I need to use the worksheet in another workbook “PLAYERS2018Userform”. I’m currently manually opening both...

So I maintain a database of Property Address', Names and Phone Numbers. I have to frequently delete information, as it is no longer needed. From time to time I delete a phone number where an obvious duplicate is found. Each phone number is kept in it's own cell inline with it's respective owner...

Hello guys, i am looking to create an excel file that will allow people to click on a name and view an image of the person. the issue that i am facing is that this file will be moved and the path that i have in the Hyperlink formula will not work once the file is moved. is there anyway that...

Hi, I need help designing a macro that will copy values on 'Sheet 2' (H7 - H23, H10 and H15 are blank) to G7, and then when new data is entered move the date from G7 to be moved to F7 and so on .. I have tried using the record macro feature and had no success. Any help will be greatly...

Hi guys, So I'm completely new to VBA and Python. I work in a Physical Chemistry lab that involves me processing a large amount of data and there's a particularly tedious task which I am struggling to get automated. I've attached an image of an excel spreadsheet as an example below for what I...

Hello All, I am using tables in my spreadsheet. When I enter new data, a new row is automatically created in each table - which is great. However, it does not insert a new row in the worksheet - so everything below my table does not get moved down the page. Is there a way of inserting a whole...

I am using Excel 2016. How do I get the Invoice MTD% Budget line moved to overlap the Invoice line? This was how it was originally set up, but I added Last Year and it moved. This chart is from a Pivot Table. Changing the column order of the pivot table did not work. Thanks, Rodney

I'm trying to move only cells in column C that are bold to the adjacent cell B, then plus one roll down so that they align with the non bold text beside it Ex: C1 Bold Text Here C2 Non Bold Text Here C3 Bold Text Here C4 Non Bold Text Here So, I need to get C1 moved to B2, and C3 moved to B4...