Please help! Please help!

G

New Member
Joined
Aug 19, 2002
Messages
41
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........
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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

Well-known Member
Joined
Jun 30, 2002
Messages
1,416

ADVERTISEMENT

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

New Member
Joined
Aug 19, 2002
Messages
41
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

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS

ADVERTISEMENT

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

New Member
Joined
Aug 19, 2002
Messages
41
Thank you, I now have it in my excel, will walk thru the steps to create the HTML image.
 

G

New Member
Joined
Aug 19, 2002
Messages
41
I tried to make this smaller....
Value Call Form Test.html.xls
ABCDEFGHIJKLMN
1sp2CountyvaluecatRenditionf_valueThiswillbeaformonadifferentsheet!
23994GA-BALDWINCOMPUTERS5270752707
33994GA-BALDWINFURN&FIX663913662647
43994GA-BALDWININVENTORY20760362076036EntityKMartInc.-BPP
53994GA-BALDWINMACH&EQP00
63994GA-BALDWINOTHER12671267Store#3994CityCountyBALDWINSTGA
73994GA-BALDWINVEHICLES00
87595GA-BARROWCOMPUTERS6040360403
97595GA-BARROWFURN&FIX6831436831432002Computers$52,707
107595GA-BARROWINVENTORY24973682497368RenditionFurn&Fix$52,707
117595GA-BARROWMACH&EQP00ValueInventory$52,707
127595GA-BARROWOTHER12871287Mach&Eqp$52,707
137595GA-BARROWVEHICLES00Other$52,707
143685GA-BARTOWCOMPUTERS5601356013
Sheet1

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

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
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
 

Forum statistics

Threads
1,144,330
Messages
5,723,740
Members
422,512
Latest member
MHau5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top