HI.. Please share sample file..
Thnks On Fri, Jun 1, 2012 at 2:12 AM, Dan Brimley <dkb...@yahoo.com> wrote: > I have been asked to help with a bunch of Excel functions and programming. > There are a few that are beyond my level. I didn't come up with these > ideas, just trying to help the person who did, so the only details I have > are what they gave me. Any ideas on the following needs would be great: > > -Can we link times in cells to the time and date of the computer so that > it will change color when it is past that time and date in the computer. > For example if it was 10a.m. today then any times or dates before 10a.m. > would have red cells and times after 10 am would be green. > > - Also I have written a sort macro for some data on google drive and made > a button that user can click to sort data. Unfortunately the 2 columns I > wanted sorted have to be manually selected then I can click the button and > sort the data. I want to be able to just click the sort button without > selecting data. Is that possible to put in my macro? Whenever I click on my > sort macro button without selecting the 2 columns it gives me an error code > stating “cell reference out of range (line3).” I am not sure what I need to > change in my line 3 of code. > > - On a different spreadsheet I would like to keep one day ahead of today > and have a macro that automatically deletes older days. For example today > is Monday so I would have Saturday and Sunday above that with 4 or 5 rows > of data below each day heading. I want a macro that deletes the Saturday > heading and the rows below it but keeps Sunday through Friday. > > -Is it possible two have two columns sort by date and then by time > automatically without the use of macros? > > -I am trying to create a rolling spreadsheet. For example every time a new > month/row is added to the spreadsheet all the previous data will rotate > down. Not only will it rotate down but once the month is below a certain > row the value will be multiplied by a percentage. Is this possible to do? > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
