Add and Replace columns on Different Sheet

Hi

I am trying to create a Macro where it will look at row 6 Sheet 1 and if finds "A" (which may be multiple columns) add those columns together and put the total on Sheet 2 column B. If row 6 has "B" add those columns together and put on Sheet 2 Column C.

Any help is greatly appreciated!

Re: "add those columns together"
Do you want to sum the total found A's and B's in Row 6?

Thanks for getting back to me, thank you and I should have been more clear. I would like all the columns with "A" which may have twenty rows end up on Sheet 2 with the sum of all the rows in column B.

So a quick example:

Sheet 1 Sheet 2 Column B

A A A

1 2 1 4
2 3 1 6
1 2 3 6
1 1 0 2
3 1 0 4

I hope this helps please let me know if you have additional questions.

At the top yellow banner it explains how to attach a workbook.
Preferably a before and after example with an explanation on how you arrived at the result.

It is pretty simple...I do it manually now...by looking at for all column A & B manually adding the columns and posting on Sheet 2....Some months have many more columns and rows could change as states get added. Hopefully this helps if you need further clarification, please let me know. Thanks

This should get you going.
Sheet2 should be empty. Clearing Sheet2 of all data can be made part of the code if you want.
If you want it for all individual values (A, B, C, D) of Row 6 in Sheet1, you have to let us know.
There is faster ways but data range dependent, this should be sufficient.

Please Login or Register  to view this content.

Thank you so much...everything worked great. I really appreciate your help!

Thank you for letting us know that all is working as per request.
Good Luck and stay safe.