Don, ok I've removed all unneccessery values. So when the macro will find NOT blank cell should be executed. as you see this is a forecast file so people will fill it in advance. refering to hirring, so maybe in the future (as a immigrent in different country I'm not getting as much) right now as you can see whole Saturday I'm sitting at home on the computer and try to do something to imprese employer and in the near future be promoted. 2 months ago you've told me to get the book and learn. I've done it. Bought a book for excel, and learning from this forum. Next step will be a book for VBA, but still not there. If can help me will be great. Regards, Pawel
________________________________ From: dguillett1 <dguille...@gmail.com> To: excel-macros@googlegroups.com Sent: Saturday, July 14, 2012 7:42 PM Subject: Re: $$Excel-Macros$$ macro with multiple rows There are some cells in column M that are NOT blank (contain values) but are NOT formulas. So, please clarify It seems that it is not necessary to fill in all of the cells in a column until data from that column is needed. So, a “worksheet_change” event macro that fires upon some cell changing may be more appropriate. Is this a project you want me to do for free or for hire? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Saturday, July 14, 2012 11:37 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro with multiple rows Hi DON, so what I need is check if in eg cell M10 is function (not empty cell) copy this function to column O:DO ( the same row ) and after calculation copy range O:DO and paste as a text. and make a loop ... cell M11 ... M12 ... and so on, if you can help me I will be appreciated. Regards, Pawel ________________________________ From: dguillett1 <dguille...@gmail.com> To: excel-macros@googlegroups.com Sent: Saturday, July 14, 2012 5:24 PM Subject: Re: $$Excel-Macros$$ macro with multiple rows I do NOT understand your need. Give examples if M___? is ______then copy the VALUES to col O:DO etc Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Saturday, July 14, 2012 9:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ macro with multiple rows Sorry All correct file Hi All, I'd like to ask you help me with writting macro, problem is I've no idea how to do it? In column "M" there are functions (colour in white) that need to be copied accross rows (started from column "O"), but only these functions. When in column "M" there is nothing macro should be checking next cell in column "M". Macro should be copied function (from column "M") accross columns "O" to column "DO", and after that save results as "text". So for the future use I'd like to add additional product and macro will doing the same for this additional items. Please if you can check and help me in this. Regards, Pawel-- 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 -- 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 -- 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