corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Excel


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel
Tom G
Member
Registered: 4th Aug 08
Location: Cheshire
User status: Offline
9th Nov 12 at 10:09   View User's Profile U2U Member Reply With Quote
Combined a few sheets of data this morning from a pivot table.

The data on sheet 1, which i copied sheet 2,3,4 onto, is carrying formatting.

An example of this, is when i filter it will only filter the first 29 - which was on the existing sheet
Tom G
Member
Registered: 4th Aug 08
Location: Cheshire
User status: Offline
9th Nov 12 at 10:09   View User's Profile U2U Member Reply With Quote
Sorted - Saved as a CSV then back across
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
9th Nov 12 at 13:22   View Garage View User's Profile U2U Member Reply With Quote
You can also use Paste Special and choose what to carry over.

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1654
21st Mar 03 at 00:15
by Red_Corsa		  
is there a program that...... chris_uk Geek Day 6 1875
16th Jun 05 at 00:47
by Dan B		  
Excel Help AndyKent Geek Day 3 1439
6th Oct 07 at 10:22
by aPk		  
need an excel like programme (for free) Shane Geek Day 12 1751
13th May 08 at 14:55
by pow		  
Microsoft Excel strick206 Geek Day 10 1458
6th Jul 11 at 14:46
by Sam		  

Corsa Sport » Message Board » Off Day » Geek Day » Excel 29 database queries in 0.0091519 seconds