|
Register | Diddy Kart | Articles | All Albums | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
LinkBack | Thread Tools | Display Modes |
#11
|
||||
|
||||
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 |
#12
|
||||
|
||||
Quote:
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] |
#13
|
||||
|
||||
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] |
Tags |
excel, google fail, nerds |
Thread Tools | |
Display Modes | |
|
|