Welcome to the FTS Forum - Read the introduction here

Avatar
Please consider registering
Guest
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Feed
Topic Rating: +1 Topic Rating: +1 (1 votes) 
sp_TopicIcon
FDD add P&L Sheet
sp_NewTopic Add Topic
Avatar
Beginner
Members
Forum Posts: 2
Member Since:
January 27, 2019
sp_UserOfflineSmall Offline
1
November 4, 2019 - 11:54 am
sp_Permalink sp_Print sp_EditHistory
0
sp_QuotePost
sp_ReportPost

Removed.

Avatar
Beginner
Members
Forum Posts: 2
Member Since:
September 17, 2018
sp_UserOfflineSmall Offline
2
November 17, 2019 - 5:27 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

Hi 

Probably a stupid question but the new master files have come in.. FDD.. How do you add them to the previous master file to make 1file..I’m not much good with excel

Cheers. 

Avatar
Moderator
Members

Moderators
Forum Posts: 30
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
3
November 17, 2019 - 7:25 pm
sp_Permalink sp_Print
+1
sp_QuotePost
sp_ReportPost

In the “old” data sheet

  • Go to the first data cell (cell A4), top left of sheet. Pressing ctrl + [home] should help too.
  • Press ctrl + [down arrow] to go to the lasr row of data
  • Press just [down arrow], so you are positioned at the first empty row.

In the new data sheet

  • Go to the first row of data (row 4?)
  • Click on the row number to highlight the whole row
  • Press crtl + [down arrow] to select all the new data
  • Press ctrl + c to copy the new data

In the “old” data sheet

  • Press ctrl + v, this should paste all the new data in
  • Save and you are done.

Think those are all the steps!

Arthur

Avatar
Beginner
Members
Forum Posts: 2
Member Since:
September 17, 2018
sp_UserOfflineSmall Offline
4
November 18, 2019 - 5:21 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

Thanks mate I’ll attempt it tonight much appreciated 👍🏾

Forum Timezone: Europe/London
Most Users Ever Online: 92
Currently Browsing this Page:
1 Guest(s)
Forum Stats:
Groups: 4
Forums: 22
Topics: 99
Posts: 511

 

Member Stats:
Guest Posters: 2
Members: 3588
Moderators: 1
Admins: 2
Administrators: Ian, Geeky Boy
Moderators: ArtTest