ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy columns to last populated rows (https://www.excelbanter.com/excel-programming/332137-copy-columns-last-populated-rows.html)

geb

Copy columns to last populated rows
 
I need to copy columns F - J (formulas) down to the last row with data in
columns A - E.
The columns A - E have the data and F - J have the formulas.
The numbers of rows will vary.
The columns A - E are populated by importing a .csv file.

Any help would be much appreciated.

geb

Copy columns to last populated rows
 


"GEB" wrote:

I need to copy columns F - J (formulas) down to the last row with data in
columns A - E.
The columns A - E have the data and F - J have the formulas.
The numbers of rows will vary.
The columns A - E are populated by importing a .csv file.

Any help would be much appreciated.


geb

Copy columns to last populated rows
 
Just to clarify the question:
I want to copy forumlas in F2-J2 down to the last row of data,
for example A2-E(last row).

"GEB" wrote:

I need to copy columns F - J (formulas) down to the last row with data in
columns A - E.
The columns A - E have the data and F - J have the formulas.
The numbers of rows will vary.
The columns A - E are populated by importing a .csv file.

Any help would be much appreciated.



All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com