| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy A1:d1 if Column A has total spend
Hi,
Theres four columns of data A:D. If Column A has "Total Spend ", copy header A1:D1 and paste it on the second row below Total Spend. So for example, A1 B1 C1 D1 Vendor Category Option Spend ABC IBM MAC Total Spend (Blank Row) Automatically Paste Vendor Category Option Spend Sample Vendor1 Sample Vendor2 Sample Vendor3 Total Spend Vendor Category Option Spend Any help is appreciated. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding top 20% of spend dollars in a column | New Users to Excel | |||
| How can I calculate total spend on items that have different values | Excel Worksheet Functions | |||
| Copy Total to the following row in Column A | Excel Programming | |||
| How do I estimate the year spend if spend is $26000 as of May? | Excel Worksheet Functions | |||
| Column Total Needed via Macro | Excel Programming | |||
Threaded Mode
