updated

Hi All, I need a macro where the formula should get updated based on cell value. I have a refresh button, when i select the refresh button, my Cell T1, U1, V1 and W1 should get updated as below. If my Cell "A1" is "All" then Cell T1 "All" else "Vlookup(formula)". If my Cell "B1" is "All" then...

Hello, I have a Userform that utilizes two textboxes for To and From date fields. The intent is to allow user to enter two different dates in the fields; however, I would like the "To" textboxB field to automatically be updated with whatever date the user has entered in the "From" textboxA...

I have a spreadsheet that I have exported from SharePoint. When I update the data from SharePoint, it updates a Pivot Table and graph. When I click data refresh or even better, when I click on a button that I create, I want the data to refresh and the date that the spreadsheet is updated to be...

<tbody> Sheet 1 Remarks A1 ABC. </tbody> <tbody> Sheet 2 Remarks A1 ABC. EFG. HIJ </tbody> I have 2 sheets which are duplicates in data. Sheet 1 is the master sheet and the Sheet 2 is for someone to add any additional comments. Just say I have updated with more comments in the remarks...

I pull data from an SQL backend, which has to be processed, I have no ability to update the stored data, apart from CASE / REPLACE TYPES. I have an Excel Sheet with updated values, and data that is important but not collected in the SQL. Basically I have two tables, I have one common value...

My programs have variables declared as Int and Long. I'm in the process of converting my programs so they would work in 64 bit Office. I know my APIs will have to be updated but what about "simple" variables such as Int and Long? Would they need to be updated (eg change Long to LongLong) or...

Hi all! I have a spreadsheet that I use to track versions of multiple applications for multiple clients. I was hoping to be able to keep a history of the previous version number in a different worksheet(i.e. app1 version history, app2 version history, etc.) upon change to the current version...

Hi All, I have a matrix that I need to update based on a list I have. Essentially, if the list shows completion, I'll need the matrix to be updated with an "x" Example, I have this table: <tbody> Name1 Training1 Name2 Training2 Name2 Training4 Name3 Training3 Name4 Training1...

I am looking for a way (probably a macro), to automatically save the date/time in a cell every time a file is updated I have a large spreadsheet, that is frequently updated by multiple users. I am hoping to have a cell show the date, time, and possibly the username of the last person who saved...

I currently have code that will send an email automatically once a value is changed in a cert cell see below. I want to include the value from another cell in the body of the email how do I do this? example of what I need. Headers = Date (A2) Run# (B2) Status (C3) 2/2/17...

Hi guys, this might be an easy formula but I cant figure it out and would like some help! I have some data that is being provided by a thermocouple and I would like the value to be automatically updated in column H1 corresponding to the F column table. I have tied with Vlookup formulas but...