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
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!
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
Last edited by BadlySpelledBuoy; 04-19-2022 at 03:10 PM.
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.
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
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
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
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
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
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.
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" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks