updating

So, I need to keep the NOW() and TODAY() from changing every time I change a cell or open the spreadsheet. I need the columns C, (TODAY()), F and G (NOW()) to stop updating once there is a time or date in the column. Thank you for the help! If you need anymore information Let me know.

I'm wonder if there is a macro out there or that can be written that changes the values of the existing series of a chart? I have 28 charts and each chart has multiple series in them. I have created dynamic name ranges for all of the series y values and the series x value is the same dynamic...

Im sure i turned some switch off, I just dont know where/what to do to get my cells to update again. My cells are not updating on any of my spreadsheerts. To update my cells, I must go to each cell, highlight the function and hit Enter to get thde cell to recalulate the function. I...

I have two seperate files in excel and I need to keep both. One contains sheets that records the individual sales of each employee for all the time working in the company, the other one includes all the sales of the company (includes all employees) for each month, it has a tab for each month...

Hi Situation; taken a copy of a sub directory containing 4 excel files which are linked to each other. Using the copied versions of the file I've renamed the modified the file names through Windows Explorer. For example 'File 1 140513' to 'File 1 310513') - essentially the copied files are...

*** THIS IS AREPOST AS I CAN’T FIND THE ORIGINAL POST ***<o:p></o:p> <o:p> </o:p> Hi. I’m anewbie to Access but seasoned in Excel and VBA. <o:p></o:p> <o:p> </o:p> Starting in row2 of an Excel worksheet I have 1 to 50 rows containing 7 columns of data thatif not found in an Access table of over...

I have a master sheet with employees' Details. Maintaining sheet1 for Passport datas, sheet 2 for visa datas, and sheet three for qualification and misc.datas. What I like is instead of going every sheet to update the records or correction, i would prefer to enter data in a single sheet based...

I have a code that initially sets ScreenUpdating to False, but in the middle of the code it calls another subroutine and for some reason it actually shows me some (not all) actions (ie, when it selects a new sheet I get to see that). I have been following ScreenUpdating Property through...

I have an issue with links to other workbooks updating (or actually not updating). I am using Excel 2010 on a PC with WIN 7. Department managers complete financial projection files (workbooks). I have prepared a summary file (workbook) that will pull data from each of the departmental files...

Hello, I am very new to VBA code. I am trying to write a macro where based on the response of a target cell, a number of rows will hide or unhide. Here is the code that I currently have, and it works. Private Sub Worksheet_Change(ByVal Target As Range) If Range("C62") = "Yes" Then...

I am using excel 2010. I have a macro-based employee leave system that works by couting the number of days shaded with a certain colour and thus calculating leave days taken, remaining and entitled... I have a single workbook with multiple sheets for different employees. However, when I...

Hi, I now looked throughout the net for days and haven't found a sloution for my problem. Here a short explanation. What I want: To show my coworkers and colleagues a graph of development of the actual sales on the actual day to see were are we going. What do I have: I have a Excel file...

I have a product sheet with product names, costs, and quantity. I have a quote sheet that has all the products on it but using an autofilter it only displays products with quantities greater than zero. Unfortunately when I change a quantity value in my source sheet the autofilter needs to be...

Hey! I have a lot of data on an excel spreadsheet which has many columns for different required fields of pieces of data. New data can be input using a user form, and this works well. However now i would like the user to be able to search for a row of data and update/edit the details of this...

Hi I have a rather big excel file that has lots of hyperlinks. Unfortunately Excel has decided to change the path in all of these hyperlinks when i moved the file. Now for some reason it doesnt change then back.. Any ideas how to do this / why it did it in the first place? Thanks