Macro is inserting cells in one column, need it to insert in 2nd column as well
I have a macro that is comparing column A to column B and where B does not match A it is inserting a cell and moving the other cells down a row so that the values match again. I have descriptions in column C that i need to move along with column B. Is there a macro for this?
Thanks so much!
Why dont you post your macro here? We can edit it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
sounds like you could do something simulair with a vlookup function?
Can you post an example?
Here is my macro. It is comparing values in row P with values in row F. When P does not match F... It is inserting cells and shifting cells down in Row P until they match F again. Row Q has a description in it. I just want Q to move down with the value that also moves in P. How do I add this?
THANKS!!!!
Please Login or Register to view this content.
Last edited by arlu1201; 06-01-2012 at 09:39 AM. Reason: Please use code tags in future.
What about adding this in for example columns R and S:
R1 = F1
S1 = Vlookup(F1; P:Q; 2; False)
No that isn't working. Column Q doesn't relate to F. It is just wording that needs to stay aligned with the values that are in column P.
Try changing this linetoPlease Login or Register to view this content.Please Login or Register to view this content.
This worked!!!!!!!!!!!!! YES!!!!!! I just jumped out of my seat! hahaha! Thank you so so so so much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks