Need An Excel Expert

by 11 replies
13
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
#main internet marketing discussion forum #excel #expert
  • 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
  • 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.
    • [1] reply
    • 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
      • [3] replies
  • 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..
  • 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."
  • 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
Join the discussion

Next Topics on Trending Feed