The VBA code below is to copy data over from a For Sales tab over to an itmof tab and an itbof tab. This code is linked to a button and when I click it all the data is copied over to the proper rows and columns. It works very well. I need either an addition onto this VBA or an entirely new VBA code to do the following...

Code:

Please Login or Register  to view this content.
Here is what I need added to the VBA or second VBA code to do the following:

On the itmof tab:
  • On the itmof tab, I need the letter A to automatically be populated in column C if there is a value (number or letter or both) in column B starting with Row 2 and below. Every cell that doesn't have a value in it should just be left alone and not auto populated with the letter A.
  • On the itmof tab, I need the number 1 to automatically be populated in column K if there is a value (number or letter or both) in column B starting with Row 2 and below. Every cell that doesn't have a value in it should just be left alone and not auto populated with the number 1.

On the itbof tab:
  • On the itbof tab, I need the letter A to automatically be populated in column C if there is a value (number or letter or both) in column A starting with Row 2 and below. Every cell that doesn't have a value in it should just be left alone and not auto populated. Every cell that doesn't have a value in it should just be left alone and not auto populated with the letter A.
  • On the itbof tab, I need the letter N to automatically be populated in column T if there is a value (number or letter or both) in column A starting with Row 2 and below. Every cell that doesn't have a value in it should just be left alone and not auto populated with the letter N.
  • On the itbof tab, I need column I to automatically be populated with (column L multiplied by 1.08 and rounded to 5 digits if there are more than 5 digits) if there is a value (number or letter or both) in column A starting with Row 2 and below. Every cell that doesn't have a value in it should just be left alone and not auto populated with (column L multiplied by 1.08 and rounded to 5 digits).

Any help would be greatly appreciated, if you need more clarification please ask.

Thanks!