Please help! Please help!

[G]

Earlier I posted a question, please if someone can tell me if this is doable or not.....

I have a sheet "DATA" with 100's of rows of information, some of the data in column A is duplicated as it represents a specific store. I have created a form that when you enter the store # the remaining data will automatically populate. However I am stuck in 1 area. There is no way for me to know exact cell locations for my data, so I need to base my formula on a range. If there is someone who can assist me, I will send a condinced example of what I am working on.

Please! Please! Please........

 

[plettieri]

It looks like you posted someting similar, apparantly not enough of a complete answer....sending a short sample and the expected outcome would improve your odds of getting a viable solution...you can use the colo utility noted below..

pll

 

[G]

What is a colo utility?

 

[plettieri]

This is a HTML utility for displaying your spreadsheedt sample into the message body of this forum....it is found just below the message box.... described as: "Download Colo's cool utility for displaying your Excel Worksheet on the board"....follow the instructions after clicking on down load.


pll

 

[Ekim]

Look down at the bottom of this page. You will see:

"Download Colo's cool utility for displaying your Excel Worksheet on the board."

Regards,

Mike

 

[G]

I am trying to post a small example, however what is the addin I want to save? I am reviewing the directions and not understanding.

 

[plettieri]

D:


Which part do you not understand after you have unzipped the file....are you getting some error messages?

Save the Addin to your Addin Directory.
Typical Dir locations are:
C:Program FilesMicrosoft OfficeOfficeLibrary
C:WINDOWSApplication DataMicrosoftAddIns
If you do not know where your Addin Dir is then;
Do a search for *.xla you should be able to get
your Addins path from the results.

Now in Excel on the Main Toolbar select
Tools > Addins....This Addin should be Listed there.
If it is not then your will need to either manually
browse & load in OR Close & Reopen Excel.


pll

 

[G]

Thank you, I now have it in my excel, will walk thru the steps to create the HTML image.

 

[G]

I tried to make this smaller....

Value Call Form Test.html.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	sp2	County	valuecat	Rendition	f_value	Thiswillbeaformonadifferentsheet!
2	3994	GA-BALDWIN	COMPUTERS	52707	52707
3	3994	GA-BALDWIN	FURN&FIX	663913	662647
4	3994	GA-BALDWIN	INVENTORY	2076036	2076036	Entity	KMartInc.-BPP
5	3994	GA-BALDWIN	MACH&EQP	0	0
6	3994	GA-BALDWIN	OTHER	1267	1267	Store#	3994	City		County	BALDWIN		ST	GA
7	3994	GA-BALDWIN	VEHICLES	0	0
8	7595	GA-BARROW	COMPUTERS	60403	60403
9	7595	GA-BARROW	FURN&FIX	683143	683143		2002		Computers	$52,707
10	7595	GA-BARROW	INVENTORY	2497368	2497368		Rendition		Furn&Fix	$52,707
11	7595	GA-BARROW	MACH&EQP	0	0		Value		Inventory	$52,707
12	7595	GA-BARROW	OTHER	1287	1287				Mach&Eqp	$52,707
13	7595	GA-BARROW	VEHICLES	0	0				Other	$52,707
14	3685	GA-BARTOW	COMPUTERS	56013	56013
Sheet1

This message was edited by G on 2002-10-03 09:14

 

[plettieri]

i'm sorry but I still don't understand what is it you want to see ...you say....

"There is no way for me to know exact cell locations for my data, so I need to base my formula on a range"

Do you want to see the exact cell location where the data was pulled from?...Please clarify...

pll