| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy data to all cells in group
Hi All,
I have a very large spreadsheet (over 21k rows) that I need help with. I need the data in column A to copy to each row in the section. A sample spreadsheet is attached with my desired results. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data to all cells in group
On Tuesday, August 12, 2014 11:47:59 AM UTC-7, Cywy wrote:
Hi All, I have a very large spreadsheet (over 21k rows) that I need help with. I need the data in column A to copy to each row in the section. A sample spreadsheet is attached with my desired results. Thanks in advance +-------------------------------------------------------------------+ |Filename: samplecfw.txt | |Download: http://www.excelbanter.com/attachment.php?attachmentid=982| +-------------------------------------------------------------------+ -- Cywy add another column right after column A and use this formula to populate all the way down. Then copy column B and paste the values (paste special) into column A. =IF(A2="",A1,A2) Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy data to all cells in group
On Tuesday, August 12, 2014 11:47:59 AM UTC-7, Cywy wrote:
Hi All, I have a very large spreadsheet (over 21k rows) that I need help with. I need the data in column A to copy to each row in the section. A sample spreadsheet is attached with my desired results. Thanks in advance +-------------------------------------------------------------------+ |Filename: samplecfw.txt | |Download: http://www.excelbanter.com/attachment.php?attachmentid=982| +-------------------------------------------------------------------+ -- Cywy sorry the formula in my first response is incorrect. use =IF(A2="",B1,A2) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy changing group of cells from Sheet1 to Sheet2 | Excel Programming | |||
| Automatically Copy Data from One Group of Cells to Another | Excel Programming | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| How can i copy a group of cells in a row to a column? | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Linear Mode
