Perth-WRX.com  

Go Back   Perth-WRX.com > Off Topic Discussions > Non-WRX Discussion
Register Diddy Kart ArticlesAll AlbumsBlogs FAQ Members List Calendar Search Today's Posts Mark Forums Read


Welcome to Perth-WRX, click here to register!

Reply
 
LinkBack Thread Tools Display Modes
  #11  
Old 16-08-2008, 07:14 AM
DAN682's Avatar
Sign me up!
Nazi Sled Driver
 
Join Date: Jul 2005
Location: Mandurah
Posts: 2,364
Thanks: 25
Thanked 13 Times in 9 Posts
DAN682 at standard level
Send a message via ICQ to DAN682 Send a message via MSN to DAN682 Send a message via Yahoo to DAN682
Default

Ok I need help again too.....

I have a very archaic way of invoicing but it works and one day I will get up with the 2000's and install quicken/myob but for the minute it is excel and it works.

So I have a couple of hundred excel sheets.
What I need to do is get excel to pull certain cells from each sheet and paste them into a new worksheet.
So I have an invoice with the:
Clients Name lets say (A1)
Description (A3)
Date it was invoiced (H1)
Total Price (H30)

How do I make excel pull A1, A3, H1 and H30 and paste it into a line on a new worksheet and make it do it to the other few hundred and paste it to the same sheet on a new line?

I thought I may be able to use Apple Automator but I have no idea how to use that program.

Cheers
Reply With Quote
  #12  
Old 16-08-2008, 10:32 AM
Poncha's Avatar
DCCD Donut Driver
Member
 
Join Date: Sep 2007
Location: SOR
Posts: 134
Thanks: 1
Thanked 0 Times in 0 Posts
Poncha at standard level
Default

Quote:
Originally Posted by Kato
Ta Joe, but there are about 450 individual items on the list in about 3000 rows. I just want a list of the individual items, not worried about the total of them.

Interestingly with a filter they are all listed in the drop down box, but I just need that in some cells instead.
Pivot tables work a treat for this stuff.
Select the 3000-odd rows you want, including the header columns.
Go to the task bar, Data, "PivotTable and PivotChart Report".
Hit next, next (making sure that you've got the correct data range you want to filter selected), next (just chuck it on a new worksheet), finish.
Now just click and drag the name of the column from the "PivotTable Field List" you want to get the 450 items of into the "Drop Row Fields Here" box.
__________________
MY06 STI
[STI 006]
Reply With Quote
  #13  
Old 16-11-2010, 09:18 AM
Kato's Avatar
Burnout!
Member
 
Join Date: Jul 2005
Location: Pimp Corner
Posts: 7,079
Thanks: 7
Thanked 120 Times in 75 Posts
Kato is a guruKato is a guru
Default

Ok epic bump...

I want to print a specific filter to a page. Normally I would just filter, hit the drop down and select the items I want to display... But again, there is just hundreds of them to do and I'm lazy.

Is there any way to print a specific filter to a page?

i.e. Data is like the following:


And I want to filter say each item in 'Column ID' so I can print that per page
__________________
[COLOR="Gray"]550Nm off a 2L... Just wish it was in the dak dak...[/COLOR]
Reply With Quote
Reply

Tags
excel, google fail, nerds

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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




Welcome to Perth-WRX, click here to register!

All times are GMT +8. The time now is 04:57 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Content Relevant URLs by vBSEO