Need An Excel Expert

15 years ago

Hi Blase

If no-one here can answer this, there's a forum at MrExcel.com MrExcel Message Board - Powered by vBulletin . Put your question in there and there will usually be an expert along in minutes to help you.

Chrissie

Thanks

{{ DiscussionBoard.errors[430603].message }}

getsmartt

15 years ago

Pulling a whole column is the same as pulling a single cell. Put your formula to pull the first cell in the top cell, then hover over the lower right corner of the cell, drag the small black square down to populate the remainder of the cells for that column.

Let me know if this isn't what you are looking for as there are other ways to accomplish this.

Thanks
1 reply

Signature

Was mich nicht umbringt, macht mich stÃ¤rker

{{ DiscussionBoard.errors[430606].message }}

Blase

15 years ago

getsmartt,

Lets say master A1 = Boy, A2 = Men, A3 = Girl, A4 = Woman.

I want to have speed sheet A show A1 - A4 in
column "c" 1-4.

What I can do is go to spreed sheet A, C1 and put in =
then go to the master and highlight A1 and hit enter.

A1 is then saved into C1 in spreed sheet A.

I can't do it more than one cell at a time.

I would also like to be able to put A1, B2, and C3
all in 1 cell in spreed sheet A.

Thanks,
Blase

Thanks
3 replies

Signature

"Nothing Happens Until Something Is Sold"

{{ DiscussionBoard.errors[430651].message }}

tecHead

15 years ago

Originally Posted by Blase

getsmartt,

Lets say master A1 = Boy, A2 = Men, A3 = Girl, A4 = Woman.

I want to have speed sheet A show A1 - A4 in
column "c" 1-4.

What I can do is go to spreed sheet A, C1 and put in =
then go to the master and highlight A1 and hit enter.

A1 is then saved into C1 in spreed sheet A.

I can't do it more than one cell at a time.

I would also like to be able to put A1, B2, and C3
all in 1 cell in spreed sheet A.

Thanks,
Blase

That's kinna what I meant about "locking" the cell references; (I think this is what you're talking about). IF the cell reference is to follow a specific order on sheet A and referenced as such on sheet B and/or C... appending the reference cell with the $ symbol "locks" Excel into knowing you wanna follow that particular order.

"Logic" dictates that this should span across sheet:cell referencing, as well.

So, after you set the first cell.. just copy and paste and since Excel is 'locked' it will follow the logic of the lock...

HTH
PLP
tecHead

Thanks

Signature

Learn Everything You Need to Know About CryptoCurrencies
Automation is the primary conduit to successful relaxation

{{ DiscussionBoard.errors[430667].message }}

Manuel Viloria 15 years ago

Originally Posted by Blase

Lets say master A1 = Boy, A2 = Men, A3 = Girl, A4 = Woman.

I would also like to be able to put A1, B2, and C3
all in 1 cell in spreed sheet A.

Thanks,
Blase

Hi Blase,

What is in cells B2 and C3?

You can try this formula in say, cell E1 (in spread sheet A):

=Sheet1!A1&Sheet1!B2&Sheet1!C3

(I'm assuming your Boy/Men/Girl/Woman data is in the
worksheet called "Sheet1")

Kind regards,
Manuel Viloria
- Thanks
- 1 reply
Signature
>> Get More Traffic Now www.ManuelViloria.com <<
{{ DiscussionBoard.errors[430855].message }}
- PettyL111 15 years ago
  
  try integrating VB and excel. No need for an excel expert as long as you are good in vb
  
  Thanks
  
  Signature
  Get Free Videos Here for Revolutionary New Niche Marketing
  
  {{ DiscussionBoard.errors[430861].message }}

getsmartt

15 years ago

Originally Posted by Blase

getsmartt,

Lets say master A1 = Boy, A2 = Men, A3 = Girl, A4 = Woman.

I want to have speed sheet A show A1 - A4 in
column "c" 1-4.

What I can do is go to spreed sheet A, C1 and put in =
then go to the master and highlight A1 and hit enter.

A1 is then saved into C1 in spreed sheet A.

I can't do it more than one cell at a time.

I would also like to be able to put A1, B2, and C3
all in 1 cell in spreed sheet A.

Thanks,
Blase

Try this in your above senario, after you enter your formula into C1, copy c1 and paste it to c2, you should see the value from A2. You can also copy C1 and select c2-cx and paste and it should paste the proper formula to replicate a2 - ax.

Pulling A1, B2 and C3 into a single cell depends on what you want to do with the data, if you want Manuel's formula is a start, you could also use a delimeter i.e. =Sheet1!A1 & " - " & Sheet1!B2 & " - " & Sheet1!C3 show Value of A1 - Value of B2 - Value of C3. if you need to combine the cells mathmatically that is possible as well.

Thanks
1 reply

Signature

Was mich nicht umbringt, macht mich stÃ¤rker

{{ DiscussionBoard.errors[430922].message }}

Blase 15 years ago

I just wanted to thank you all for your responses.

The good news is I know it can be done, so
at the very worst I can make a post over in
"Warriors For Hire" and get it done.

You all gave me something to try.

Thanks,
Blase
- Thanks
Signature
"Nothing Happens Until Something Is Sold"
{{ DiscussionBoard.errors[431912].message }}

coco28

15 years ago

You can automate this process if you use VBA (Visual Basic for Applications) which you can access via the macros menu in Excel. I've done something similar in the past so its not impossible, but you would need to know a bit of VBA..

Thanks

{{ DiscussionBoard.errors[430622].message }}

Ron Douglas

15 years ago

Originally Posted by Blase

Hi,

I just want to know if this can be done.

I have an excel spreed sheet filled with data,
lets call it "Master".

I use the info in master to build 2 other spreed sheets,
which are then turned into tab files and uploaded as data
feeds. Each of these need different data from the master.

Is it possible to automate this process?

Or is it possible to use formulas in the 2 spreed sheets
to pull from the master?

I know how to pull info from one sheet to another,
but only by the cell. I need to pull a full column
and I need to pull 3 cells from the master into 1 cell
on another spread sheet over and over again.

Currently I am doing all of my mashing with Note Tab.
Then putting in back into the spreed sheet and saving
the whole thing as a tab file.

I hope this makes sense.

Thanks,
Blase

As long as each spreadsheet has a common data point (employee id, for instance), you can set up a formula to bring data in based on that common data point. The formula is called a VLookup. I'm pretty sure you can set up a nested vlookup formula using a combine function - ie: "formula 1 & formula 2 & formula 3."

Thanks

Signature

Ron Douglas, MBA, CFA, NY Times Best Selling Author, Making Money Online Since 2001

FREE Internet Marketing Tips | Secret Recipes | Nantucket | Buy Non-IM Solo Ads

{{ DiscussionBoard.errors[430630].message }}

tecHead

15 years ago

If you're looking to do it dynamically.. then (brief overview).. you'd wanna have all three sheets in the same "workbook".

You then reference the sheet:column:cell in the cells of the sheet(s) you wanna merge the data into.

You can lock cell position by appending the cell reference with the $ symbol.. just do a search in the provided help and it will be very clear.

Hope this helps..
PLP,
tecHead

Thanks

Signature

Learn Everything You Need to Know About CryptoCurrencies
Automation is the primary conduit to successful relaxation

{{ DiscussionBoard.errors[430632].message }}

Need An Excel Expert

Trending Topics

Google Ads, landing pages, and Clickbank links

Carry out better target audience research

A Very Strange Internet Problem

YouTube gets shopping display tools and affiliate partnership updates

Melb, Interat, Flower Show 2024