6-4

This Week's Hot Topics

• Unprotecting a sheet once a text box is selected

  • Started by dpaton05
  • Sep 8, 2020
  • Replies: 49

  Can you unprotect a sheet once a text box is selected and then reprotect it again when it is unselected? I do not want to use active x text...
• OFFSET function with multiple table

  • Started by xdenama
  • Sep 9, 2020
  • Replies: 43

  I have 100++ sheet (table) with same format with difference high (total row not fix, will change). How to combine all table (sheet) in one sheet...
• Question about Data Validation.

  • Started by omairhe
  • Saturday at 12:00 AM
  • Replies: 24

  Hello all, I find data validation to be a useful tool in excel 2019. In cell A2 if the value = A then allow both positive and negative integers...
• VLookup Or Other To Match Data.

  • Started by fintail99
  • Sep 7, 2020
  • Replies: 23

  Hi there, I have data, as follows: Sheet1 A1: Name B1: 0.5 (this relates to total time, see Sheet2 below) C1: £25.00 (this relates to the total...
• Split a year range into one row per year

  • Started by rameez788
  • Sep 8, 2020
  • Replies: 21

  Hi all, I am new on this forum. I have attached sample data, i need someone to help me convert the left side to how the data looks on the right...
• Combine 2 var into 1 string with & in between

  • Started by bumbum2812
  • Sep 7, 2020
  • Replies: 21

  Hi Experts Please help me combine 2 var into 1 string with & in between. My data is from A1:A2 & i have below code to put in MsgBox...