update automatically

  1. A

    Chart data change via selected named range(s) in validation cell...help please...

    Hello all - I am hoping someone may have some input on this, please: I have created 5 named ranges from a table. Each named range is simply one column of data. Then created a lookup for the (names of) these named ranges (names match exactly, etc.) Once I had a lookup list, I then created a...
  2. V

    Linking excel to powerpoint

    Similar to the bookmarks function in word, I would like to have values in powerpoint linked to excel (not a graph) and automatically update as the numbers change. Example In excel: Revenue 1,234,567 In powerpoint in textbox: Revenue for the last fiscal year was 1,234,567...
  3. D

    How to maintain a distributed VBA Macro with multiple users

    <tbody> I have built an extensive program for my organization which periodically needs to be updated. I have tried having a macro that deletes all the old macros except itself and then reimports from a central repository but I run into a naming problem. Source code below. I have reference...
  4. S

    How to Update one Excel workbook with new information from another workbook (find and replace or merge)

    Hello all, I am not new to Excel, but I have never messed with formulas or documents with large amounts of information. However, I am now faced with doing weekly and/or monthly updates on a master spreadsheet/workbook that has names, case numbers, completion dates, and other personal data. I...
  5. B

    Update Excel Database in real time

    Is it possible to create a data entry form update in real time just like MS Access, also it should retreive and edit data from the table aswell. Or do I have to use MS Access or another software for this?
  6. J

    Checkbox Form-Table VBA Update Code

    I have a database tracking whether employees attend their meetings. For every meeting they attend they get paid. The attendance sheets get submitted by an upload form into my database as a Form with checkboxes for each employee. Now I want my VBA code to see that if the "AttndMeeting1" value is...
  7. S

    Automate updating a spreadsheet with a new spreadsheet.

    When we get an updated spreadsheet my job is to update the sheet to the new sheet but still have all our data we added to the old sheet. This involves checking any adds or drops. We use the address column to check. Currently: If the new sheet doesn’t have an address from the old sheet I cut the...
  8. H

    Need a formula to update info by date but also maintain old info by date

    Greetings everyone, I'm trying to write a formula to check for new data added each day with certain criteria. One worksheet has data added to it, and the other worksheet runs the calculations. So Worksheet 1 will have x number of lines of new data added to the top of the list, and each new...
  9. B

    Ad an amount weekly

    Hi I am trying to add a rent amount to a total on a weekly basis. I have a dashboard that is used by the boss and he wants to have it updated weekly. Is there a formula that can automatically reference an amount cell and add that amount to the total on a weekly basis. Say every Monday. Thank you...
  10. C

    How to automatically update countifs formula with multiple conditions

    We have a register keeping track of all our counselling referrals and I need to keep track of numbers of unallocated patients based on differing sets of criteria, as below: <tbody> First name Surname Funding Counsellor/status Angus Smith Bolton Franklin Beaumont Smith Hitchcock...
  11. D

    Updating a source range (e.g. bingo numbers not being "redrawn")

    Hello all, Seeing if there is a way of a source range being "updated" such that once a value is selected from that source, it can not be selected again? An example being something like a bingo game where once B14 has been pulled, it is out of the pool of remaining selections? Thanks in...
  12. M

    Copy and Update

    I want to copy sheet1 to a new sheet2 and then when the data changes on sheet1 I want sheet2 to automatically update. The reason is I want to able to hide some rows and columns on sheet2 to obtain a better print format. I was going to use INDIRECT however it appears I would need to manually...
  13. S

    VBA Macro to Check for Calendar Items in Outlook and Update if Details Changed

    Good Morning All, I'm trying to make a macro that links an excel list of meetings with an outlook calendar. I have created a macro so far that is able to create the entries and check to see if the entry exists by a specific date (which doesn't allow for any flexibility). I now need to make it...
  14. L

    Creating formulas to pull from specific cell in all worksheets - EXCEL2010

    I am creating a summary sheet for all the worksheets in a workbook. For example, I want to be able to sum E3 from all worksheets. I have been using something like: =Sum('*'!E3). This works fine, but each week I am adding a new worksheet to the workbook and the formula does not update with the...
  15. H

    Vba code for qty data update

    Hi Team, I am looking vba code in order to get desire output. I have several columns which contains product details, there is column called "Qty" we get request from customer and will order the goods based on available qty in our store. If available in store then will get it otherwise will get...
  16. M

    Excel macro to get the right type of X-scale in a chart

    Hi Everybody, After two hours trying to find this over internet, I finally gave up and I'd like to asf for your help! Say that in one sheet I've a table with say 500 columns and 6000+ lines. In other two sheets of the same workbook, I've made 50+ charts to get the information I want from the...
  17. R

    If True Formula

    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...
  18. M

    Adjusting Reference Cells Within Workbook

    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...
  19. S

    Need Ms Word Macro to update word content

    · 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...
  20. E

    How to link two tables so they update each other?

    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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top