+ Reply to Thread
Results 1 to 10 of 10

How to reproduce a pro-forma in Excel

  1. #1
    Registered User
    Join Date
    04-19-2022
    Location
    Calgary, Earth
    MS-Off Ver
    365
    Posts
    4

    Question How to reproduce a pro-forma in Excel

    HI,

    We had a person quit and took the master of this excel file.

    I don't know bugger all about excel, so how hard would this be to re-create and how?

    Does anyone think it's a template from someplace?

    Cheers'
    Dave C

    master form scan.jpg
    Last edited by AliGW; 05-17-2022 at 03:35 AM. Reason: Title changed - please think more carefully about your thread titles in future!

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,693

    Re: very basic question

    Hi and welcome to the forum.

    It would probably take about 2 mins to recreate if there's no functionality built in. By that I mean if there's no calculations etc.
    If there is we'd need to know what the calculations are and it could easily be replicated.

    Although to me it looks like it's been printed out and therefore completed with a pen(?)

    BSB
    Attached Files Attached Files
    Last edited by BadlySpelledBuoy; 04-19-2022 at 03:10 PM.

  3. #3
    Registered User
    Join Date
    04-19-2022
    Location
    Calgary, Earth
    MS-Off Ver
    365
    Posts
    4

    Re: very basic question

    Hi Buoy,

    No, it's not very complex, its a just a form they made and took when they left. We go thru it and finish it in pen and there are no formulas or calc's in the file.

    I have all the text from an OCR I did but I just don't know how to format that stuff in Excel being a total newbie. I'm also guessing that it was in Excel but I'm not
    100% sure of course.

    The text is easy enough to make anyway, the tricky part for me is putting it in to excel ...... it wouldn't have been done with a wizard or something do you think?

    I just has a look at the file you attached, and yep - that's pretty much it. So HOW did you do it (grin) and thanks I'm gonna steal that and use it!

    Cheers'
    Dave C
    Last edited by casondavedavec; 04-19-2022 at 03:13 PM.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,693

    Re: very basic question

    Already put one together and attached it to my previous post for ya.

    Should be printer friendly but you'll need to give that a test.

    BSB

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,693

    Re: very basic question

    Simply a case of changing the widths of a few columns, merging a few cells and typing out what you had on your picture of the form and applying some borders.
    Nothing complicated when you know what you're doing

    Steal it and use it all you need

    BSB

  6. #6
    Registered User
    Join Date
    04-19-2022
    Location
    Calgary, Earth
    MS-Off Ver
    365
    Posts
    4

    Re: very basic question

    Thanks !

    I will do that ..... I'll just cut and pate it as I need and figure out how to get the gaps to
    appear on the sheet and work on those borders .....

    Can you suggest any decent tutorials anyplace?

    Thanks again !

    Cheers'
    Dave C

  7. #7
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,693

    Re: very basic question

    Tutorials for this type of thing? Not sure about that I'm afraid.

    There are icons in the ribbon at the top of Excel that will allow you to merge cells and add borders. Simply a case of highlighting the cells you want to merge and/or add a border to then clicking the icon.

    Give me a shout if you get stuck at all.

    BSB

  8. #8
    Registered User
    Join Date
    04-19-2022
    Location
    Calgary, Earth
    MS-Off Ver
    365
    Posts
    4

    Re: very basic question

    Buoy oh buoy,

    Na I've bugged you enough, I'll go google-fu highlighting and merging cells in excel!

    I'd be wiling to be I'll get a hit or two ..... Massive Thankings Again!

    Cheers'
    Dave C

  9. #9
    Registered User
    Join Date
    12-17-2020
    Location
    south africa
    MS-Off Ver
    office 365
    Posts
    13

    Re: very basic question

    Lol, this reminds me of reverse engineering stuff. Love when people give us stuff like this. And i concur that if it has no build in functions can just recreate the page. If you then have functionality needed, ask as well. I bet there is someone that can built your functionality if you need it.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,183

    Re: very basic question

    Welcome to the forum.

    Next time you ask a question here, plaese ensure that your title meets our expectations.

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you atre new here, I will do it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. basic question
    By dogmeister in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-15-2015, 04:15 PM
  2. Very Basic Question, I Think.
    By TBarrnes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2013, 04:57 AM
  3. Basic 'or', 'and', 'not' Question
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2008, 02:46 PM
  4. Basic VBA question...
    By mattsvai in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-25-2008, 06:19 AM
  5. [SOLVED] Basic question
    By plittle in forum Excel General
    Replies: 1
    Last Post: 05-23-2006, 10:55 AM
  6. Basic question
    By hshayh0rn in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-28-2005, 04:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1