lipstick

This Week's Hot Topics

• Excel VBA Parse Column A into multiple columns help but with conditions

  • Started by BalloutMoe
  • Jun 7, 2021
  • Replies: 59

  Hello, I have a TXT file that gets imported in excel and it always ends up in column A. I am trying to split the data up however. The middle...
• Data with Different score

  • Started by sksanjeev786
  • Jun 3, 2021
  • Replies: 30

  Hi Team, I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data...
• Looping a macro through all visible sheets?

  • Started by GlennJ
  • Jun 5, 2021
  • Replies: 29

  I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated. [CODE=vba] Sub...
• Loop through Column, looking for an array of values, If NOT found, delete entire row

  • Started by blbat
  • Jun 7, 2021
  • Replies: 29

  So I tried to modify some good code from Joe4, but ran into some walls. I'm trying to modify his working loop to cycle through Column "D", find...
• VBA to extract values starting with specific character

  • Started by sncb
  • Jun 4, 2021
  • Replies: 21

  Hi all, I paste two cells of data into A1 and B1 with different formats and spacing like below and I need to extract only those values that start...
• macro/vba fix for not a blank, blank in Go To Special

  • Started by LorettaAlsop
  • Jun 8, 2021
  • Replies: 20

  I am writing vba code (thru using macros) to format a ws. In a portion of the formatting I identify the blank cells and replace them with the cell...