Posts by Driver

I have used formulas to create a worksheet from information from several other worksheet. Now, I need to sort the sheet, using data from one column.

How do I sort data, that is in formula form?

Trying to link data from a Specific Excel cell into a specified spot in a word doc

I have a sheet listing the information
A1 name

B1 address

ect

I need to figure out how to link this to my form letter to fill in the blanks "so to speak"

First thought says mail merge, but I don't seem to be able to quite get it.

Any suggestions are appreciated.

Sure there is ptobably a better way, but this may help you.

Try using the print screen button

Then open up MS paint.

Edit > Paste

Crop the part you want to use.

Save that file.

Now you can attach the file in a few formats depending on your requirements.

Hope this helps

I have a sheet listing the information
A1 name

B1 address

ect

I need to figure out how to link this to my form letter to fill in the blanks "so to speak"

First thought says mail merge, but I don't seem to be able to quite get it.

Any suggestions are appreciated.

Downloaded the utility, but it does say convert numbers to text format, but does not actually write the number out.

It just changes the format as if I had gone into excel number format and switched from number to currency or general.

But looks like a good utility..thanks for the link.

Looking for a way to have a cell linked to another display the number in text

Ex

a2=a1

a1= $950.00
I need a2 to display Nine Hundred Fifty

one thing

if my sheet name is baker then the formula is

INDIRECT(CONCATEMATE("BAKER","!B6"))

??

got it...thank so much :cheers:

Thanks for the reply. I feel like a noob asking this question, but

I'm using INDIRECT(CONCATENATE("Sheet2",ROW(6),"!B6"))

Trying to paste data from sheet 2 b6 into

sheet 1 b3

this of course is not working. Would you please explain this a little more. Thank you

I'm trying to link info from several sheets into one sheet.

I know I can just put the formula "=sheet! cell " into each cell I need it to link to, but I'm trying to drag the formula down a column and the sheets are not in the same format.

Any way I can establish the formula at the top, then drag it down the column

EX

What it's doing is

Sheet1 cell1
Sheet1 cell2
Sheet1 cell 3

I need it to do

Sheet1 cell1
Sheet2 cell1
sheet3 cell1

Any help is appreciated.