TDL76
New Member
- Joined
- Mar 13, 2013
- Messages
- 16
Hello, I've "inherited" and excel spreadsheet (database) and need to create a few macro's / vba functions. I am completely green when it comes to creating / writing code... Although I can read and understand what it needs to do. I have a few dynamic tables that pull totals from a pivot and that I need to copy and paste special values to a static table on the right. ie: =IF(B4=G4, copy & paste special values B5:B9 to G5:G9, " ").... B4 = Current Week (formula driven). G4 = static data (table used to drive charts).... This is the first of 11 tables that will need this code... The aim of this is to track / review consecutive weeks. Any help will be greatly appreciated... Thank you