LinkBack URL
About LinkBacks
Is it possible to delete a column of numbers then replace those numbers from adjacent columns and the adjacent columns are then filled with the numbers adjacent to them and so on
regards Troysie
Is it possible to delete a column of numbers then replace those numbers from adjacent columns and the adjacent columns are then filled with the numbers adjacent to them and so on
regards Troysie
You've oversimplified your sheet. There needs to be more variety in the data we're looking at. Also, since your macro doesn't actually work, use BEFORE/AFTER sheets to demonstrate what you want to occur.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There will only ever be ones or blanks in the cells
Please find attached before and after
Regards Troysie
OK. Your command button already achieves the "after". What do you need from us?
sorry iam not explaining this correctly. when i press the command button i want the column deleting and replacing with the e column and the column replacing with the f column.i put the after in the wrong columns. please find attached new before and after.every time d column is deleted i want the next column to advace into d column and so on at the moment it just deletes d column
hope this is a bit clearer
Regards Troysie
Do you mean like this?
Please Login or Register to view this content.
That is basically what I require but now i have incorporated it into my worksheet it drags the fill colour behind it. i have only applied the code to thfirst five rows up to now
Please find attached sheet
Regards Troysie
Try this:
Please Login or Register to view this content.
Thankyou that is exactly what I need
Regards Troysie
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks