Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 12th 09, 02:52 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default Trying to find easy way to copy 400K rows of data from Subtotal

I have an excel file that has over 400K rows of information. I had to
subtotal on a colums to be able to effectively run a pivot table. But now I
have to copy all teh data from the row above the total to get the rest of the
information. So say my total is in column a row 4 to get the row above I am
doing a=3. Yay, it works, but I have 25 columns that I need to do this for
and the only way I can figure how to get the information to populate all the
way down is by doing copy/paste and it pastes the formula...However when I
try to do a Special Paste it is not, so I have been doing it row by row. I am
on 129K but there has got to be an easier way!!! HELP

  #2   Report Post  
Old May 12th 09, 03:19 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 56
Default Trying to find easy way to copy 400K rows of data from Subtotal


"MnCujo15" wrote in message
...
I have an excel file that has over 400K rows of information. I had to
subtotal on a colums to be able to effectively run a pivot table. But now
I
have to copy all teh data from the row above the total to get the rest of
the
information. So say my total is in column a row 4 to get the row above I
am
doing a=3. Yay, it works, but I have 25 columns that I need to do this for
and the only way I can figure how to get the information to populate all
the
way down is by doing copy/paste and it pastes the formula...However when I
try to do a Special Paste it is not, so I have been doing it row by row. I
am
on 129K but there has got to be an easier way!!! HELP


Err wouldn't you be far better off using a proper database application such
as Access for that huge quantity of data?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

  #3   Report Post  
Old May 15th 09, 05:46 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1,696
Default Trying to find easy way to copy 400K rows of data from Subtota

So, are the only blanks the ones with subtotals?

If so, go to the first blank, make the cell = cell above...

copy the calculated cell

highlight the column, F5, Special, blanks, paste

"Gordon" wrote:


"MnCujo15" wrote in message
...
I have an excel file that has over 400K rows of information. I had to
subtotal on a colums to be able to effectively run a pivot table. But now
I
have to copy all teh data from the row above the total to get the rest of
the
information. So say my total is in column a row 4 to get the row above I
am
doing a=3. Yay, it works, but I have 25 columns that I need to do this for
and the only way I can figure how to get the information to populate all
the
way down is by doing copy/paste and it pastes the formula...However when I
try to do a Special Paste it is not, so I have been doing it row by row. I
am
on 129K but there has got to be an easier way!!! HELP


Err wouldn't you be far better off using a proper database application such
as Access for that huge quantity of data?

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)




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
Can you subtotal data in rows? hdf Excel Worksheet Functions 8 August 25th 08 09:35 PM
Can't seem to find way to have easy data entry AND analysis - idea Heidi Excel Discussion (Misc queries) 2 January 2nd 07 11:24 PM
subtotal copy-paste and delete hidden rows Winslow Excel Discussion (Misc queries) 1 December 12th 06 03:26 PM
Is there an easy way to filter duplicate rows of data in excel? Yumin Excel Discussion (Misc queries) 1 October 7th 05 08:15 PM
Excel - copy subtotal rows only Russ Excel Discussion (Misc queries) 1 September 14th 05 10:50 PM


All times are GMT +1. The time now is 10:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017