Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Post EXCEL code so It can be used by others

Status
Not open for further replies.

Rich2001

Mechanical
Mar 23, 2001
896
TO CREATE
Create as a TEXT (Tab Delimited) file.
Open in Word Pad
Select all & Copy
Select Individual Cells with formulas and copy
Paste these in lieu of the results in the text file
Copy the text
Paste in to Eng-Tip Forumn

TO RECREATE
Copy from Eng-Tip Forumn
Paste into EXCEL



1 One might say
2 Aesthetically speaking
3 On the other hand
4 Based upon inter-disciplinary considerations
5 With sensitive respect for human scale
6 Indubitably
7 Above and beyond plebian comfort objectives
8 Beyond the horizon of the human intellect
9 Architecturally thinking
10 In the final rationalization
11 the massing of major elements
12 the introduction of brutalism
13 the treatment of the main façade
14 the initial stage of conceptual development
15 the by-product of repetitive space articulation
16 the life-cycle cost control
17 the environmental impact analysis
18 energy conservation regulations
19 the structural dynamic analysis
20 the internal use adjacencies and circulation
21 must utilize and be functionally interwoven with
22 maximizes the real probability of cost overruns for
23 adds specific critical path events to
24 necessitates that urgent considerations be made of
25 requires exhaustive trade-off study to arrive at
26 is further compounded by taking into account
27 presents extremely synergistic challenges to
28 recognizes the critical necessity to subtract from
29 imposes smothering constraints upon
30 adds overriding three dimensional constraints to
31 the sophisticated design solution
32 the anticipated degree of human ambiance
33 the acuteness of the conflict gradient
34 the pragmatics of value engineering
35 the final quantitative analysis
36 the evolution of performance specifications
37 the philosophy of commonality and standardization
38 the study of true fecundity in the state of the art
39 the creation of an immortal monument to posterity
40 the final abortion


=CONCATENATE(VLOOKUP(RANDBETWEEN(1,10),A16:B55,2)," ",VLOOKUP(RANDBETWEEN(11,20),A16:B55,2)," ",VLOOKUP(RANDBETWEEN(21,30),A16:B55,2)," ",VLOOKUP(RANDBETWEEN(31,40),A16:B55,2),".")
 
Replies continue below

Recommended for you

Copy the whole message above and paste into EXCEL.

Does anyone have a VB routine to automate this? The trick is copying the formulas rather than the results?
 
one thing that might help when you want to copy formulas - hit CTRL + ` (or CTRL + ~) while on the sheet that you want to copy from.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor