moved

  1. S

    Stopping workbook being copied to desktop

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

    How do I move specific text via macro

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

    Dynamic line numbering when rows get added or swapped

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

    Long term EntryID for Outlook Messages

    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?
  5. T

    VBA To Move Column Based On Value In Row 1

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

    Compare Rank formula?

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

    Integer to string in MsgBox message

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

    dynamic listbox controltip

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

    Adding Up Columns Code Needed

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

    Move row data to another sheet based on cell value

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

    Excel Alert: Can't find Personal Macro Workbook

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

    Bring value (variable position) from rows to column

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

    Save worksheet to unopen workbook (VBA)

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

    Confusing Issue in 2016

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

    Dynamic Hyperlink

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

    Marco moving data

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

    Need help with a difficult macro - don't really know how to describe it for a title

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

    Auto-Insert new row in Table?

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

    Pivot Table Graph

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

    Move Bold Text to Adjacent Cell

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top