static

Hi all, I'm trying to enter a datestamp from a single cell entry point, and this works fine, but obviously it changes every time $A$2 is changed. (There are hundreds of entries in column "D") =IF(AND($A$2=D2,$A$2<>""),IF(E2="",NOW(),E2),"") I need the datestamp to remain static, after new data...

I would like to create a master template that I can change that automatically filters to down-line files . This is easily done via linking with static data but I can't figure out how to do it with formulas. Is there a way? Thanks in advance, Tyler

Hello! I have a tab which will pull data directly from Paypal, including names and transactions and amounts. I need to compare this growing, dynamic list against a static range of clients on another tab. If a name from the dynamic PayPal list matches the static client list, I need to pull the...

Hi, I have a sheet with a calculation in Column K for rows 2-19 of (=$J2/(1-$H$22) H22 is static adjustment %. J2-J19 is a % of total for each task Line. I want to be able to change the static adjustment % in H22 and have the values change in column K but for the totals in column K not to...

Hello! I have a tab which will pull data directly from Paypal, including names and transactions and amounts. I need to compare this growing, dynamic list against a static range of clients on another tab. If a name from the dynamic PayPal list matches the static client list, I need to pull the...

I trying to setup a spreadsheet for multiple users on SharePoint. I have a status column which is setup with a data validation dropdown list. And a column which will contain a date/timer stamp. I want the date/time stamp only to appear once a certain option is selected from the status column...

I am looking to create a data validation list that has one static value ("***ALL***") and also a dynamic list. Is this possible? I have tried the follwing forumula but it returns an error: ="***ALL***",OFFSET(DataStart_UniqueCombos,MATCH($C$6,Tables!$B$6:$B$219,0),2,$F$7) The dynamic list...

Hi All, I am using Excel 2010 and I have been asked if it is possible to insert a block arrow on each row to indicate if the row has been moved up, down or has remained static. Currently the Spreasheet contains 64 rows of data and I know it may be possible to do this manually, however, before...

Hello, I know how to do a static timestamp by using control + shift + colon, however I am trying to make a spreadsheet do this automatically when a cell is populated. For example, when someone enters a value in cell A1, I want B1 to stamp the static current time when A1 was populated. This...

Hi, I have found the following command to minimize the ribbon and have added it to my Workbook_Open commands Application.SendKeys "^{F1}" Can I revert back to the ribbon being static using another command to cancel out this one for a Workbook_Close command Many thanks

Hi All, By default, the camera tool takes a 'live' picture that changes whenever the original linked cells change. I'd like to save this live image as a static image, i.e. when the original cells change, the image does not. I've tried to copy and paste the image, but with each option...

Hi, I've been searching all day for answers to how I can pull this off. I have two tables of data where records match up when the tables are placed side by side. I have a code that currently highlights the entire row of the sheet for which cell I have active. Works great. But I also want to have...

Hi I've constructed a list of email formulas from email text values so i can use them with a VBA script. The problem I have is that I need to replace the end part of the formulas, the final cell reference, with it's static text value before I can use it. I know I can select the cell ref and...

Hi, I am using a sheet in excel which pulls data out automatically from a database. Fills in maybe 20 or so columns with orderinfo. In column A i have a unique order no. What i want to achieve is adding a column for an example C that is static. I fill in a number related to the order and i...

Hi, I wonder if you can help me? I want to add a date into cell Q when adding data into cell N but I also want to ensure that that date remains static, so when the spreadsheet is re-opened the historic date remains. Also, I want to add a date to column E which will remain static. I have entered...

I have a chart which it's "Source Data > Value" is assigned to "B1". All I need is to be able to add a new row on top of "B1" without automatically changing the "Source Data > Value" to "C1", is it possible? Thank you!

I have a form control button I am trying to use to delete a range of cells and refill, but I do not want the formula references to shift if I add rows/columns. I am aware of naming the range but I cannot think of an appropriate way to apply that fix in this scenario. Ideally I would like to do...

I have created a pivot table chart and need to add a 85% and 95% contorl limit line. I can not put it in my pivot table chart, is there a way to just add in a line. This 85 and 95% will never change, they are static.

i am doing a project for school on the lottery. my problem is that i have formulas that reference to cells A1:A10. everytime there is a lottery draw i import the new numbers to cell A1, this causes the previous data to shift down one cell, which is what i want. however the formuals that...

Hi all, i need a variable for a date which is static, global, and the value of this variable can be changed via a userform. Is that possible?? :| Excel 2003 Shie Boon Thanks