stovvy
New Member
- Joined
- Feb 12, 2018
- Messages
- 10
I can find similar posts on the forum but not exactly what I would require. I have exhausted all of my slim knowledge in both Excel and VBA in trying to complete the task so please is there someone out there who can help?
I have a spreadsheet and in column B2 it would show a numerical value that is totalled in B1. Dependent on what is shown A2 (an asterisk, etc) the value in B2 is copied to C2 but the value then is removed from B2. This would be duplicated down across the columns with the totals appearing in the Row 1 columns.
I hope this makes sense?
I have a spreadsheet and in column B2 it would show a numerical value that is totalled in B1. Dependent on what is shown A2 (an asterisk, etc) the value in B2 is copied to C2 but the value then is removed from B2. This would be duplicated down across the columns with the totals appearing in the Row 1 columns.
I hope this makes sense?