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
Avatar
Tram247
Beginner
Members
Forum Posts: 4
Member Since:
January 27, 2019
sp_UserOfflineSmall Offline
1
November 4, 2019 - 11:54 am
sp_Permalink sp_Print sp_EditHistory
0

Removed.

Avatar
MajorDisaster
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

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
ArtTest
Moderator
Moderators

Members
Forum Posts: 244
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
3
November 17, 2019 - 7:25 pm
sp_Permalink sp_Print
+1

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
MajorDisaster
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

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

Forum Timezone: Europe/London
Most Users Ever Online: 92
Currently Online: thomsch
Guest(s) 2
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Lord Dio: 120
leewillo75: 92
@capitalchrisw: 72
des911: 64
Callum: 61
Neil: 50
jamiep: 48
gurds1991: 48
chasanddave: 48
jb8426: 46
Newest Members:
anthonypuppy
norvezhskiydomteert
kenchov
haroldedump
anotherdarkhorse
martin
manazef
mmalhoubani1
kingcoz9
jesseatted
Forum Stats:
Groups: 5
Forums: 24
Topics: 255
Posts: 2043

 

Member Stats:
Guest Posters: 3
Members: 4658
Moderators: 2
Admins: 2
Administrators: Ian, Geeky Boy
Moderators: ArtTest, davefts