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:
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!
Bookmarks