Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
geb geb is offline
external usenet poster
 
Posts: 19
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
geb geb is offline
external usenet poster
 
Posts: 19
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.programming
geb geb is offline
external usenet poster
 
Posts: 19
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want only rows with populated data Pete[_7_] Excel Worksheet Functions 1 April 12th 11 04:21 PM
copy to new cells if populated srbow Excel Discussion (Misc queries) 1 April 30th 09 06:25 PM
using IF function to copy, but leave populated cell alone [email protected] Excel Worksheet Functions 5 May 12th 06 10:39 PM
how to count populated rows? Ryan Cain New Users to Excel 4 August 12th 05 04:35 AM
Copy Values to Below last Populated Cell Q John Excel Programming 2 June 29th 04 05:28 PM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"