ctrl ditto

This Week's Hot Topics

• link pictures from Sharepoint to Excel macro

  • Started by jc83ph
  • Jan 7, 2022
  • Replies: 35

  Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
• lookup match return closest to x date

  • Started by 288enzo
  • Tuesday at 5:47 PM
  • Replies: 35

  Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
• Average hours per week

  • Started by rgillson3
  • Wednesday at 10:05 AM
  • Replies: 31

  I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
• Google Sheets IMAGE Function

  • Started by excelbytes
  • Jan 7, 2022
  • Replies: 30

  Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
• Identify equipment used -No of consecutive days

  • Started by ABC1
  • Jan 7, 2022
  • Replies: 26

  Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
• Filling in data from source

  • Started by Luke777
  • Jan 7, 2022
  • Replies: 26

  Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...