Posts by AlanSidman

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.


    Remember to desensitize the data.

    1. I have no idea what you are asking. Your explanation is confusing and not clear.

    2. We cannot manipulate data in a picture

    3. Suggest you upload a sample file.

    4. Using the sample file data you upload, also mock up and upload a solution of what you want your result to look like.

    5. You may wish to explain once again the logic you use in the samples you upload

    Code Tags Added

    Your post does not comply with our Forum RULES. Use code tags around code.


    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.


    Highlight your code and click the </> icon at the top of your post window.


    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

    Using Power Query/Get and Transform, here is the result in the file




    and the Mcode that made it happen


    Code
    1. let
    2. Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    3. #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type text}, {"B", type text}, {"C", Int64.Type}, {"D", type text}}),
    4. #"Grouped Rows" = Table.Group(#"Changed Type", {"A", "B", "D"}, {{"Total", each List.Sum([C]), type number}})
    5. in
    6. #"Grouped Rows"

    Files

    • OZTEST.xlsx

      (19.6 kB, downloaded 8 times, last: )

    Using Power Query/Get and Transform, here is the Mcode generated by that action.


    Your post does not comply with our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.


    Post a link to any other forums where you have asked the same question.


    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.


    Go to https://www.excelguru.ca/content.php?184 to understand why we ask you to do this.


    I have added the crosspost reference for you today. Please comply with this and all our rules in the future


    crosspost: https://www.excelforum.com/exc…ithin-the-same-sheet.html

    crossposted: https://www.excelforum.com/exc…k-menu-item-in-macro.html


    https://chandoo.org/forum/thre…menu-item-in-macro.44402/


    Your post does not comply with our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.


    Post a link to any other forums where you have asked the same question.


    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.


    Go to https://www.excelguru.ca/content.php?184 to understand why we ask you to do this.


    I have added the crosspost reference for you today. Please comply with this and all our rules in the future

    Your post does not comply with our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.


    Post a link to any other forums where you have asked the same question.


    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.


    Go to https://www.excelguru.ca/content.php?184 to understand why we ask you to do this.


    I have added the crosspost reference for you today. Please comply with this and all our rules in the future


    https://www.mrexcel.com/board/…le-with-web-page.1135301/

    Code Tags Added

    Your post does not comply with our Forum RULES. Use code tags around code.


    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.


    Highlight your code and click the </> icon at the top of your post window.


    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

    I think the issue here was you cannot edit your post after a period of time. In such a case, put it in the next post available in the thread. No problem, I added the actual thread in both forums. But now you know. With the link to the actual thread others can see if there is any progress before venturing into the issue.

    Cross-posting Without Telling Us


    Your post does not comply with our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.


    Post a link to any other forums where you have asked the same question.


    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.


    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!


    Read https://www.excelguru.ca/content.php?184 to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).


    I have provided the crosspost today. Please observe the forum rules you agreed to when you joined.


    Crosspost: https://www.mrexcel.com/board/…-access-database.1134610/

    Code Tags Added

    Your post does not comply with our Forum RULES. Use code tags around code.


    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.


    Highlight your code and click the </> icon at the top of your post window.


    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)