Hi,
I am new to macros. I am wanting some help to create a macro to change the attached sheet in a few ways.
- Change '✓' to a 1
- Delete specific columns
- Delete blank rows (including those that have no data except the formula in AA).
- Change cells containing 1 to Green and those containing letter to red (I have done this with conditional formatting if that is easier).
Any help would be greatly appreciated.
Thanks
Simon
Hi Simon
These are fairly direct:
- Change '✓' to a 1
- Delete blank rows (including those that have no data except the formula in AA).
- Change cells containing 1 to Green and those containing letter to red (I have done this with conditional formatting if that is easier).
This is an unknown as you haven't shared that with us:
- Delete specific columns
I see your Platform is Mac Excel 2011. I'm able to test on that Platform. I'll develop on the PC then test the Code on the Mac. Tell us what Columns you wish deleted.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi,
Thanks for the offer. Sorry I haven't had the net over the weekend but I managed to play around with the code and figure out what I needed.
Simon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks