Macro for shifting contents of a particular cell
Closed
blah85
Posts
2
Registration date
Wednesday 8 October 2014
Status
Member
Last seen
10 October 2014
-
8 Oct 2014 à 07:28
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 13 Oct 2014 à 11:24
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 13 Oct 2014 à 11:24
Related:
- Macro for shifting contents of a particular cell
- Need for speed: most wanted 2005 downloadable content - Download - Racing
- How to run a macro in excel - Guide
- Run macro in excel - Guide
- How to delete a cell in word - Guide
- Shift key not working for symbols - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
9 Oct 2014 à 11:36
9 Oct 2014 à 11:36
Hi Blah,
So you want to create a different workbook for each name?!
The beauty of Excel is that you can store multiple sheets in a single workbook so that all the information is in one place. That way it is easier to find and process your data.
Best regards,
Trowa
So you want to create a different workbook for each name?!
The beauty of Excel is that you can store multiple sheets in a single workbook so that all the information is in one place. That way it is easier to find and process your data.
Best regards,
Trowa
blah85
Posts
2
Registration date
Wednesday 8 October 2014
Status
Member
Last seen
10 October 2014
10 Oct 2014 à 00:42
10 Oct 2014 à 00:42
I think I have been misinterpreted.
Please consider this example.
I am creating a directory of expenses wherein there are 4 fields (Month, Name Expense Details, Expense Amounts)
Month July
Name Expense Detail Expense Amount
John car wash 300$
Jim toilet paper 10$
harry Diner 40$
Total 350$
Now I want one workbook/sheet to have the following fields captured (Month & Total)
Month Total
July 350$
August 265$
The second Worksheet should have the following fields captured (Month, Name, Expense Amount). It would be an aggregation of all previous sheets
Month Name Expense Amount
July John 300$
July Jim 10$
July harry 40$
August John 15$
August harry 20$
Sep Jim 500$
Similarly The third worksheet should have the following fields captured (Month, Expense Details, Expense Amount). It would be an aggregation of all previous sheets.
Its seems fairly simple as a concept but as I'm new to this, its been a little tough to work it out beyond this.
Please consider this example.
I am creating a directory of expenses wherein there are 4 fields (Month, Name Expense Details, Expense Amounts)
Month July
Name Expense Detail Expense Amount
John car wash 300$
Jim toilet paper 10$
harry Diner 40$
Total 350$
Now I want one workbook/sheet to have the following fields captured (Month & Total)
Month Total
July 350$
August 265$
The second Worksheet should have the following fields captured (Month, Name, Expense Amount). It would be an aggregation of all previous sheets
Month Name Expense Amount
July John 300$
July Jim 10$
July harry 40$
August John 15$
August harry 20$
Sep Jim 500$
Similarly The third worksheet should have the following fields captured (Month, Expense Details, Expense Amount). It would be an aggregation of all previous sheets.
Its seems fairly simple as a concept but as I'm new to this, its been a little tough to work it out beyond this.
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
13 Oct 2014 à 11:24
13 Oct 2014 à 11:24
OK, that makes more sense.
Could you post your workbook with sample data and result data so I can see where your data is located and where your result needs to go (as well as the number of sheets) ?
Use a file sharing site like www.speedyshare.com or ge.tt and then post back the download link.
I will see what I can do to run the process automatically.
Best regards,
Trowa
Could you post your workbook with sample data and result data so I can see where your data is located and where your result needs to go (as well as the number of sheets) ?
Use a file sharing site like www.speedyshare.com or ge.tt and then post back the download link.
I will see what I can do to run the process automatically.
Best regards,
Trowa
