| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
gather data in selected cells and transfer value to another cell
Afternoon,
I want to create a script (or macro) that will run a program that looks at speific cells, get their values (regards if value is zero) and display the results in A1. Current i'm using the below line but it is tedious and tiring considering i have over 50 columns. Please advise when you can. Cheers. Below line, the result is displayed in A1 as " etc... =CONCATENATE($M$1,"@",$AT$2,"@",C37,"@",ROUND(F37, 2),"@",ROUND(F38,2),"@",ROUND(G37,2),"@",ROUND(G38 ,2),"@",ROUND(H37,2),"@",ROUND(H38,2),"@",ROUND(J3 7,2),"@",ROUND(J38,2),"@",AP37,"@",ROUND(AP38,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
| Macro to transfer contents of 'Selected' cell to alternate cell. | Excel Worksheet Functions | |||
| auto transfer data in sheet2 (selected data) | Excel Worksheet Functions | |||
| need to jump down 4 cells, gather data, jump another 4 | Excel Programming | |||
| Automatically transfer selected data to another sheet on print | Excel Programming | |||
Threaded Mode
