syncronize

  1. R

    Syncronize list box value on multiple worksheets - if one changes, they all change

    Used the standard Data Validation option to create an in-cell drop-down List. There are 3 user Worksheets. Each of the 3 Worksheets have the same in-cell drop-down list. They all use the same Named Range criteria for the list. If the user is on Worksheet 2 and changes the selection from 1 to 2...
  2. K

    Sync different workbooks

    Can someone please help me with my issue before I'm going nuts:confused: I have 6 employies that have their own workbook shared with onedrum.com and me. I have a workbook that shall get their workhours synched with my workbook, and at the same time synch back to their workbook. This is...
  3. N

    Synchronizing Excel 2003 List With SharePoint 2007 Using VBA

    Hi Everyone, I tried searching for a post on this but didn't come up with any results and I was wondering if someone could help me out trying to synchronize a list between Excel 2003 and SharePoint 2007. Currently what I did was use Data --> XML source to bing in the data from SharePoint...
  4. E

    Function parameters won't work correctly

    Hi eveyone, My question seems to be unique, so far I have failed to find a solution. I call a function from an Excel sheet which gets live data from a stock server. My Function parameters are bid, ask, number of shares sold, number of shares bought, and several other relevant data. The...
  5. G

    Synchronising Excel Documents Across SharePoint

    Hi guys! I'm new to this forum, so apologies if this has come up somewhere else. Although I've had a thorough look around and I haven't been able to find the answer, so I'm hoping you may be able to help me. By the way, I'm fairly new to this level of Excel coding, so you may have to bear with...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top