update

Hi all, is there a work around for coloring a tab in a shared workbook. i have a workbook which myself and another share for my supplier accounts and the tabs are colored depending on if they need to be actioned. i update them by coloring the tabs Red, Orange & Green on the tabs themselves and...

Hello, I have the below code but I am looking to add something to it. Once the Macro has run but before the message box stating update complete, what I would like it to do is: go to Sheet "CAPA Log", copy rows A1:P1, paste in an e-mail, then copy the last row with data (A:P) and paste that...

Hello, I have three pivot tables. The rows and values vary between each but the Filters are ALWAYS the same. I am looking for a way that when I update a filter on one, it updates the filter on the other two pivot tables as well so that I don't have to update each one manually. Thanks for the...

Hi all, Using Office 365. Is there a way to update the Data Source for all of my Pivot Tables that are connected to 9 Slicers? When I try to update the first Pivot Table, I receive a warning message How can I update all Pivot Tables at the same time to defeat the warning? Thanks, -Lou

I have two rows of data the top row is either a number or a blank The next row is a date, when the number was entered This is carried out by the 1st date being the project start & then all the other dates +7 days. I have some vba that takes the date that the update is carried out on (always...

this code to search with in range and update the information. I have only 1 item in the range and it says there is nothing? Can someone assist to correct this problem. Thank you SearchString = ListBox1.Column(1, ListBox1.ListIndex) Set SearchRange = Range("T18:T" &...

Hi All, I'm trying to load data from excel to sql server. For this I created an insert statement which is very generic means this statement can be used for any table. I just have to change the name of the sheet and it will automatically pick up the names of the columns and their values from the...

Hi guys I have a spread sheet ( sheet 2) with a list of data customers name , so my columns have B4=code , C4=Name , D4=ORDERS , E4=D/O/O , F4=Y/N , G4=NOTES , H4 = LEG , I4 =DATE, j4=TIME How do I update the (sheet 1) Customers info and changing the order of columns when input...

Is is possible to build an "action button" in PowerPoint 2016, that will allow the links on that slide to update by clicking on, instead of right-clicking and selecting "Update Link" on the pop-up menu? Is there a macro that can be assigned to the "blank" button in PowerPoint? If possible, this...

Good day currently I am using this formula,but I would like the formula to return a "0" if the answer is 0.5 or less. =IF(E8>0, (F7-(F8-(E8*55))),IF(F8=0,"",(F7-F8)))

Hi all. I have the update form with a combobox that lists all names on spread sheet. Once one is selected it then populates the entire form with remain data in accordance with the name that was selected. Now, when I click on the update command button, I'm getting an error. I am watching this...

Hi, is it possible when I click on a cell it inserts the current date. I do not want this to update on every cell. Thank you

INDEX(Sheet2!$L$3:$L$20000,SMALL(IF(FREQUENCY(IF(Sheet2!$K$3:$K$20000=$B2,Sheet2!$L$3:$L$20000),Sheet2!$L$3:$L$20000),ROW(Sheet2!$L$3:$L$20000)-ROW(Sheet2!$L$3)+1),1)) I have a workbook with two sheets. Sheet 1 has the above formula which points to Sheet 2. Sheet 2 is where I paste my data. I...

Excel 2013 with Data Model rather than Power Pivot, I have a process I'm using to produce various subsets of my overall dataset. My process generates 6 .csv files which are built as tables in a Relational Database. I've added each table to the Data Model and setup the correct relationships so...

I'm having trouble with this code working as a deactivate. As of right now I have it working as a 'Update Name' Command Button which works fine but users are forgetting to 'Hit' the button and the names they are looking for are not showing up in the updated list. So, if I could have the list...

Looking for help with the below.... Basically, I want to track the status of an item. If i am to enter a date lets say in column C which is titled " Item setup date" i would like the status in column B to automatically change of i enter that date. But again, if i enter data further down...

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. Thanks

I am writing a macro to open and update an Excel file in SharePoint online using Excel in Office 365. I can open the file but it open as read only. I found the solution to add ActiveWorbook.LockServerFile after opening the file but I get application-defined or object-defined error when I...

Is it possible to link data from a Excel spreadsheet into a LIVE PowerPoint slide? So if I have PowerPoint running in Slide Show mode, is it possible (without any macros or VBA) to have another person updating a shared excel spreadsheet and have that data update instantly within my live...

I have an excel template that I keep in sharepoint. When I get a new client, I use the template to create a new file. I was really hoping to link a few cells in the file to the metadata in sharepoint either upon cell value change or saving the document. I linked them through custom...