Excel Wizrds in the house? - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Excel Wizrds in the house?

Moderator: Baseball Moderators

Excel Wizrds in the house?

Postby reiser » Wed Dec 07, 2005 4:32 pm

I know there's a few here!

I need to copy several CSV's into an Excel Template that has a bunch of formula's...is there any way I can copy Column D into Column C-painlessly? In other words, I have a formula Adding B+C=D, and so my columns kind of skip.
reiser
Minor League Mentor
Minor League Mentor

User avatar

Posts: 641
Joined: 17 Feb 2004
Home Cafe: Baseball

Postby Amazinz » Wed Dec 07, 2005 4:53 pm

I am not totally sure I understand the question but I'll take a shot. You can just load the CSV in Excel as a new workbook and then copy and paste the columns you want into your template. The more precise way of doing it is to open the template and import that data from the CSV. You can select the individual columns to import and choose where to place them.
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby reiser » Wed Dec 07, 2005 4:55 pm

Amazinz wrote:I am not totally sure I understand the question but I'll take a shot. You can just load the CSV in Excel as a new workbook and then copy and paste the columns you want into your template. The more precise way of doing it is to open the template and import that data from the CSV. You can select the individual columns to import and choose where to place them.


yeah that's pretty much it-I hadn't tried importing, I'll give that a shot.
reiser
Minor League Mentor
Minor League Mentor

User avatar

Posts: 641
Joined: 17 Feb 2004
Home Cafe: Baseball


Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 14 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Thursday, Jul. 31
(All times are EST, weather icons show forecast for game time)

Chi White Sox at Detroit
(1:08 pm)
Colorado at Chi Cubs
(2:20 pm)
St. Louis at San Diego
(3:40 pm)
Philadelphia at Washington
(7:05 pm)
Seattle at Cleveland
(7:05 pm)
LA Angels at Baltimore
(7:05 pm)
Cincinnati at Miami
(7:10 pm)
indoors
Toronto at Houston
(8:10 pm)
Minnesota at Kansas City
(8:10 pm)
Pittsburgh at Arizona
(9:40 pm)
Atlanta at LA Dodgers
(10:10 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact