need vba help to sum the overall total ,>2 days total & change cell values

[breadwinner]

dear experts

I have set of values with undefined range i want make changes with sum and change the text value where find criteria..


i want change cell text ORDER RELEASE DATE as DAYS OF LOGIN
i want change cell text Days > 6 as Days > 3

i want count the range row wise start from where cell find 1st till how long end might be (4th,5th,6th or 100rd) result in where finds column header is "ToTal"
i want count the range of column start from where cell find 1st after 2cell down till end of serialno result in where find column header is Days > 3 in B:B
i want count the range of column start from where cell find 1st overall till end of serialno result in where find column header is total in B:B


find the attachment..

[breadwinner]

any experts need ur help

[alansidman]

This forum requests that you not bump your threads for at least 24 hours. Please look over all the rules of the forum, but I point out for your benefit some information from the forum rules

Want to get your question answered quickly?

• Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
• On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
• Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
• Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
• Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
• If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

I have looked over your spreadsheet. I cannot correlate your request to the spreadsheet information. Your description of what you are trying to do is to vague. Please be specific in what you are doing. While it may be clear to you, we cannot see inside your head. Identify specific cells and specific actions. It would also be beneficial if you showed us a spreadsheet of what it would look like after the changes, even if you have to manually type them in. In this manner, we would have a better idea of what you are looking for.

Keep in mind that this is a worldwide forum and it is weekend in many parts of the world. We are all volunteers here. We work in the forum when we are inclined to. Your issue, unfortunately for you, is not our emergency. Be patient.

[breadwinner]

sorry sir i was little bit hurry i am quiet new to forum i am not aware of rules of forum.. forgive my hurry...keep help me sir

[alansidman]

I will repeat what I found when I viewed your file.

I have looked over your spreadsheet. I cannot correlate your request to the spreadsheet information. Your description of what you are trying to do is to vague. Please be specific in what you are doing. While it may be clear to you, we cannot see inside your head. Identify specific cells and specific actions. It would also be beneficial if you showed us a spreadsheet of what it would look like after the changes, even if you have to manually type them in. In this manner, we would have a better idea of what you are looking for.

Until you clarify your issue, it is difficult to help you.

[breadwinner]

thanks sir for being time spend with my post...
find the attachment i want start row sum where "A" text value found in any one of column header till before Total header value ,i want get sum value result in where column header find " Total ".

macro run code on existing values replace by new sum values..

[alansidman]

Try this:

Please Login or Register  to view this content.

[breadwinner]

Thanks Sir Pretty and Perfect works ......Well done

[alansidman]

You are welcome. It would be in your best interest to learn how to use the Macro Recorder. This is pretty simple code that could have been generated using the recorder and then if you had issues, post the recorded macro for fine tuning. Glad to have been help.