I have 3 separate worksheets that I have used some VB code to bring all into the same workbook, Then I use some more code to merge all the workbooks into the same tab. Now what i want to do is copy some of the cells to another cell if null. For example:
If Column D is Null Copy the data from Column P.
Can anyone help with that. I need to do a few columns like that, Then if I get that working I may want to take it a step further and delete the entire "P" Column from the worksheet.
Also is there a way to run all macro's at once or combine them into one?
Thanks in advance for the help
If Column D is Null Copy the data from Column P.
Can anyone help with that. I need to do a few columns like that, Then if I get that working I may want to take it a step further and delete the entire "P" Column from the worksheet.
Also is there a way to run all macro's at once or combine them into one?
Thanks in advance for the help