|
|
|
|
#1
06-10-2019, 11:15 PM
|
|||
|
|||
The file with the copying all 12 months issue, in row 1, in which column is "Current Fcst" located ?
and is there anything else in row 1 ? I'd prefer to be looking at a file rather than having to ask. 
|
|
#2
06-10-2019, 11:44 PM
|
|||
|
|||
|
In the current example the F-H is actuals and I-Q is Forecast. But that changes every month so ideally the code would be dynamic. Perhaps identify the forecast columns with zeros where the actuals would be copied? I have a file with better data but I'd prefer to send it to you than to post it. Thx
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to combine multiple rows in to one through an equation on EXCEL? | emitb | Excel | 1 | 07-31-2018 04:22 PM |
| Combine multiple 'form data' into one all-encompassing Word document | Padraig Clarke | Word | 1 | 04-19-2017 05:28 AM |
| Summarising data from multiple rows | mardecl1 | Excel | 5 | 01-06-2017 04:05 AM |
| Macro to Combine Multiple Rows into One Row | brunssl2 | Excel Programming | 10 | 01-13-2015 01:56 PM |
 data roll up under unique identifier
|
NewGirl | Mail Merge | 1 | 11-15-2012 04:47 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode