sheetscity

This Week's Hot Topics

• VBA ARRAY CODE HELP

  • Started by roykana
  • Friday at 10:38 AM
  • Replies: 31

  Dear all master, Please help for vba array code remove numbers based on specific contents of cell. ORIIGINAL [ATTACH type="full"]41084[/ATTACH]...
• VBA to find values in several columns, based on common value in a different column, then copy paste to different sheet

  • Started by mlepesant
  • Jun 16, 2021
  • Replies: 26

  Hello, New to the forum. Good excel skills but almost no VBA experience. I have a file that provides me with Bill of material for different...
• Can someone help me understand the differences between dictionaries and arrays

  • Started by dpaton05
  • Jun 15, 2021
  • Replies: 23

  I am struggling to understand the differences between when you should use a dictionary as opposed to when you should use a dictionary. Can someone...
• Auto add last entered data in same row

  • Started by Detectiveclem
  • Sunday at 2:52 PM
  • Replies: 31

  Hi can anyone help with a formula which will allow the last date entered in a row to be captured in the last date entered cell (E.G. Cell A2) And...
• Error with Loop

  • Started by Jeeremy7
  • Jun 16, 2021
  • Replies: 22

  Hello, I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ? Also I saw that some...
• Check a number is between two columns and then pick a value

  • Started by ashok89jan
  • Monday at 2:56 AM
  • Replies: 20

  I have the data like given below till Low =0.5, High= 1.49, and Grade = 1 My need is, if I enter a number in a different cell, say 95, I need that...