update automatically

I am looking 2 formulas. Cell R5 contains data and cell R15 tells me if this data is true. I therefore want cell R16 to check if Cell R15 is True and therefore show the data that is contained within cell R12. If Cell R15 is false I don't want cell R16 to show anything. The 2nd...

I have a workbook where I have several summary worksheets; each worksheet records the progress of several students on an achievement (i.e., "Complete", "Partial" as each student achieves the goal). The students are organized in columns - student 1 is tracked in column A, student 2 is tracked in...

· User must open the word document (attached)<o:p></o:p> · A Input box must appear (all read text fields ) <o:p></o:p> · User will type in the multiple information<o:p></o:p> · Then user click on Update & Save button<o:p></o:p> · Must update information from...

Hello, I have this table that I currently use that's now grown to over 300 columns wide, and I want to split it up into two (and in the future, multiple) smaller tables. Basically, each record represents an account number, and the columns contain information about the account. I would like to...

Ok, I'm working on a form in access 2010. I'm attempting to have the form update two fields, (A title and a description field) when you type in the code associated with each title/description. The code field is 6 characters long. I would like it to search the "dictionary", the table that...

Hi friends, I dont get the hang of VBA inspite of having learnt C++. :confused: anyways, i need help in coding, i want to make it possible to refresh a particular sheet on clicking a button. i can create the button and even assign the macro. but the code for macro, to refresh i don't know how...

Hi all, hope someone can help me please. I have 2 workbooks that are linked together. Book1 pulls information from Book2 and displays it in a table and graph for colleagues to use. Book 2 is password protected so that only I can view the details in it. The password is currently "lion". When...

I have several sheets in a workbook, the first one is called "daily", the others are called "stock1", "stock2", "stock3",...., "stock20". In the sheet called "daily" I paste everyday information abouth the sheets "stock1", "stock2", etc. This is the information I copy in the "daily" sheet...

I am new to VBA and have been trying to write something that will update multiple worksheets from a master based upon the name of the cell in column C, with limited success. I would like to copy each entire row over to a worksheet of the same name as the cell in column C for any particular...

The Skinny: I am trying to put together a budget planner for my company where each division has the option to give a part of their allotment to each other. I need each division's workbook to have the latest update from the others: Division1 - gives $500 to both Division2 and Division3...

I don't know if this is possible but I am hoping so. I run several performance reports daily and weekly. On Monday's I have to run the reports twice, once to compile the prior week recap and the second time to produce the current weeks performance. Currently between runs, I have to archive...

A column is validated to a drop down list on another worksheet. The information has been inputted into the cells using the drop down list. The original data in the drop down list have been updated. For example, the original list included: Type 1 Type 2 Type 3 ... Now the list has been...

Hello again, So, been trying to make a macro that updates a formula in a cell with values from a loop. What I am basing this on is an example found on google. Sub Macro2() x = Range("A1") y = Range("A2") Range("B2") = "= sum(C" & x & ":C" & y & ")" This will insert the formula...

I'm trying to make a date interval legend in a userform. I don't have any issue with getting values into text boxes, I just can't rap my head around making the updating date interval into code or sheet formulas, and causing the code or formulas to update every new pay period. Example: I use...

Hi, Can anyone help me with creating a bar chart that will update with the info it is showing when i tick or untick a check box. So far I have my data list with check boxes and my bar chart however it shows all the data, I only want it to show the ones that are ticked, but for it to update...