In my spreadsheet in column A I will have a series of numbers and colored cells.
I mostly uses green and red, Green is a buy and red is a sell. I want a macro that can subtract the red from the last green cell. They may be 5 cells apart sometimes more.
Thanks,
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
Attached is simple example i want to put macro in B10 that subtracts the last green cell from a 10. Sometimes that distance is 10 cells sometimes 5.
Thanks,
Put this code into a standard codemodule of your workbook, and save the file as a macro-enabled .xlsm. Then use the function like so:
Look for your green fill
=LGC(A10,A1:A9)
or
Look for any fill
=LCCell(A10,A1:A9)
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks