Use CONCAT to pull data from different places

**burrjc** · 08-22-2019, 04:46 PM

I have a pricing sheet which includes 4 templates. I used a concat to summarize the data onto another sheet. However, when copying the CONCAT it only increments the cells by 1, which is incorrect for the format I have. See pictures for ref.
I need to pull data from column A-F, row 5-16, and then again column H-M, row 18-27 (for example).

Can anyone assist? I feel like there might be an IF function involved, but I just can't figure it out

TIA!Data.JPG Summary.JPG

**FDibbins** · 08-22-2019, 04:53 PM

1. Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. "Latest" doesnt say which version you are using

2. To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

3. You don't really show columns or rows in your pic, so it's hard to make out what is where. Can you show what your formula is that you are using, and what you need it to show/do?

**burrjc** · 08-22-2019, 05:06 PM

The paperclip drop down won't allow me to attach a file. Here is my concat formula:

=CONCAT('Pricing 1-4'!M7," PACKAGE CONSISTING OF:",CHAR(10),CHAR(10),"VALVE: ",'Pricing 1-4'!I8," ",'Pricing 1-4'!J8," ",'Pricing 1-4'!I7,CHAR(10),"TORQUE REQUIREMENTS INC. MANUFACTURER RECOMMENDED SAFETY: BREAK: ",'Pricing 1-4'!K10," ",'Pricing 1-4'!I9," RESEAT: ",'Pricing 1-4'!M11," ",'Pricing 1-4'!I9,CHAR(10),CHAR(10),"ACTUATOR: ",'Pricing 1-4'!I11," ",'Pricing 1-4'!I12," ",'Pricing 1-4'!J11,CHAR(10),"TORQUE OUTPUT AT ",'Pricing 1-4'!K14," ",'Pricing 1-4'!K13,": START: ",'Pricing 1-4'!K14," ",'Pricing 1-4'!I14," END: ",'Pricing 1-4'!M14," ",'Pricing 1-4'!I14)

This pulls data from the first table. I want to copy this formula to pull data from the next table which is located in the same sheet, and so on.

**JeteMc** · 08-27-2019, 07:15 PM

As to: "The paperclip drop down won't allow me to attach a file" please reread Ford's post, it does not mention the paperclip icon, which as you state, does not work for this site.
Let us know if you have any questions.

**FDibbins** · 08-27-2019, 11:39 PM

Originally Posted by burrjc

...The paperclip drop down won't allow me to attach a file...

Perhaps you missed my instructions on how to upload a file?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.