Quote:
Originally Posted by Kimberly
The code does exactly what you asked for in your original post, and it does create output that matches the first example file you uploaded (before you changed it).
"Mainly the code you posted didn't allow me to insert an entire row" --Your original post specifically said that Column B should not change, and the original example file did not have inserted rows, just inserted cells in Col A. Also, the current file you uploaded doesn't show that entire rows have been inserted.
"and when I switch the columns the code didn't work" --Of course it didn't. That is because what you asked for and what you wanted were entirely different.
"I need more than that, attached is an example contains "Before" and "After" sheets that exactly describe the other problem I faced when applying your solution" --I don't know if you are saying that this file shows the issue after the code is run or after.
And in this last sample file... On the After sheet, WHY aren't there inserted ranges in rows 28 thru 32? I have written another macro, but it doesn't stop at row 27, so I hesitate to post the code until I know what you expect it to do.
|
I do completely understand your points, but since I have a very limited time to finish the data, I started working on them manually yesterday, so I faced many other problems more than those found on my original post :S like I have to shift the entire row, and not only one cell!! Any way, the situation is exactly as found in my attached file, and the "Before" and "After" sheets are a very small sample on the data I have to deal with, the "Before" sheet contains the data I received in addition to the full data column I created, and the "After" sheet contains the data after being modified according to the full data column I created, and I didn't applied your code on them. In the Attached example the column I created is column "A" and it is named "Date". But in any ways, I deeply appreciate your effort and your great help, and now I am hoping you will give another code that will help me. I really did my best!! And after this issue I am more determined to take an extensive Visual Basic courses or any other programming language courses!! These advance courses are really a must these days!! :S
Thanks again
