extracting info

Countryboy69 · Dec 13, 2018

is there a macro that once an external file is open it pulls certain info from it and plugs it in to various sheets?

Countryboy69 · Dec 13, 2018

I'm already running a macro that will open a certain file now I need one to pull a few cells of info out and place them to various sheets according to input on the master sheet

Macropod · Dec 13, 2018

Yes. See, for example https://www.mrexcel.com/forum/excel...ro-copy-data-every-nth-row-another-sheet.html. Each such macro, quite naturally, is tailored to the requirements of the particular situation.

Countryboy69 · Dec 13, 2018

Is there a way for it to find a certain number? Then use that row to find said info?

Macropod · Dec 13, 2018

How about setting out exactly what it is your proposed macro is supposed to achieve - including relevant workbook/worksheet names, cell addresses and so on. Doling it out piecemeal is a sure way of guaranteeing minimal interest and maximum frustration.

Countryboy69 · Dec 14, 2018

I want it to look up a workbook from a designated input cell, then search that workbook for match based on another cell input once that is achieved it needs to pull from that row a few cells of info. I'd like the macro to activate if a certain cell is filled hope this makes sense

Countryboy69 · Dec 15, 2018

Ok here's a question what function would I use to have multiple rows insert data on another sheet until another column cell is entered (ex. Enter input into an A cell all B cells after that go to sheet 2 where the A cell is copied to until another A cell is inputted then the B cells under it go to the second A cell that was created on sheet 2) I've looked and looked cant find any answers please help just need a nudge in the right direction

Countryboy69 · Dec 16, 2018

TotallyConfused · Dec 16, 2018

Countryboy69 said:
Ok here's a question what function would I use to have multiple rows insert data on another sheet until another column cell is entered (ex. Enter input into an A cell all B cells after that go to sheet 2 where the A cell is copied to until another A cell is inputted then the B cells under it go to the second A cell that was created on sheet 2) I've looked and looked cant find any answers please help just need a nudge in the right direction

I’ve spent several minutes studying your post #7 , and I still am not exactly sure what you are trying to do. It seems as if you want some data from one sheet, (but which one?) to appear on sheet 2. If my assumptions are correct as to what you are trying to accomplish, I know of no one function that would be able to do what you want. A macro will have to be written. Looking at your sentence I’ve put in red, I have several questions. You say:

Code:

“Enter input into an ‘A’ cell” – but which cell? e.g. A1 or A2 or A3 etc.
“All ‘B’ cells after that” – sounds like perhaps several but how many? 
                                     - Is it always the same number?
                                     - I presume starting on the same row as what is in column ‘A’.
“go to sheet 2”               - Are the ‘B’ cells copied or moved to sheet 2? A big difference.
            At a guess, if they are copied, then it would appear as if both sheets are the same,
            in which case your source data may be able to be blocked and sent to sheet 2 that 
            way.
You had said in your post [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6]#6[/URL] , that you would like the macro to be activated if a certain cell is filled. Which cell?

It would be a big help to us if we could see a sample of your data. If it is confidential, make up something that represents the layout of your source data sheet and also how you want the destination, (sheet 2) to look like. Use the same data from one sheet to the next so we can follow it as it is processed.

Do you have any code already written? If so, let us see what you have because that is always a big help. If it only partially works, where does it stop and what are the error messages? If you have some code, please enclose it within the code blocks. If you aren’t sure how to do this, highlight all your code, then click on the # button along the top of your screen.

e.g.

Code:

 place your code here

I know it isn’t always easy to fully describe what you are trying to do, because it is clear to you, but remember, we have no idea except for what you tell us. The more accurate and complete the instructions are, the better we can assist you.

In all fairness, I have to say that I’m fairly new to Excel and VBA, so I may or may not be able to help you. However, there are many people here that are very talented and I’m sure would love to work on a solution.

TotallyConfused

Countryboy69 · Dec 16, 2018

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A

[/th][th]

B

[/th][th]

C

[/th][th]

D

[/th][th]

E

[/th][th]

F

[/th][th]

G

[/th][th]

H

[/th][th]

I

[/th][th]

J

[/th][th]

K

[/th][th]

L

[/th][th]

M

[/th][th]

N

[/th][th]

O

[/th][th]

P

[/th][th]

Q

[/th][th]

R

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1

[/td][td=bgcolor:#000000]

JC 12/15/2018

[/td][td=bgcolor:#000000]

MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY

[/td][td=bgcolor:#000000]

INC BOX

[/td][td=bgcolor:#000000]

D-box

[/td][td=bgcolor:#000000]

Disputes

[/td][td=bgcolor:#000000]

D.A.W

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2

[/td][td=bgcolor:#000000]

Barcode

[/td][td=bgcolor:#000000]

Daughter B/C

[/td][td=bgcolor:#000000]

W.A.D.

[/td][td=bgcolor:#000000]

Full wt.

[/td][td=bgcolor:#000000]

Empty wt.

[/td][td=bgcolor:#000000]

Waste Wt.

[/td][td=bgcolor:#000000]

Types

[/td][td=bgcolor:#000000]

Destination

[/td][td=bgcolor:#000000]

NPC/PSC

[/td][td=bgcolor:#000000]

Notes

[/td][td=bgcolor:#000000]

Full Wt.

[/td][td=bgcolor:#000000]

Empty Wt.

[/td][td=bgcolor:#000000]

Box #

[/td][td=bgcolor:#000000]

Full Wt.

[/td][td=bgcolor:#000000]

Full Wt.

[/td][td=bgcolor:#000000]

Empty Wt.

[/td][td=bgcolor:#000000]

Full Wt.

[/td][td=bgcolor:#000000]

Empty Wt.

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3

[/td][td=bgcolor:#000000]

766535

[/td][td=bgcolor:#000000]

7890

[/td][td=bgcolor:#000000]

2505

[/td][td=bgcolor:#000000]

5385

[/td][td=bgcolor:#000000]

20

[/td][td=bgcolor:#000000]

BIN

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: NOTES[/td][/tr][/table]

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A

[/th][th]

B

[/th][th]

C

[/th][th]

D

[/th][th]

E

[/th][th]

F

[/th][th]

G

[/th][th]

H

[/th][th]

I

[/th][th]

J

[/th][th]

K

[/th][th]

L

[/th][th]

M

[/th][th]

N

[/th][th]

O

[/th][th]

P

[/th][th]

Q

[/th][th]

R

[/th][th]

S

[/th][th]

T

[/th][th]

U

[/th][th]

V

[/th][th]

W

[/th][th]

X

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1

[/td][td=bgcolor:#000000]

Date

[/td][td=bgcolor:#000000]

Barcode

[/td][td=bgcolor:#000000]

Waste WT

[/td][td=bgcolor:#000000]

40 S/l

[/td][td=bgcolor:#000000]

20' S/l

[/td][td=bgcolor:#000000]

B-25

[/td][td=bgcolor:#000000]

Drum

[/td][td=bgcolor:#000000]

Exelon

[/td][td=bgcolor:#000000]

Other

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#000000]

Bin Side Intermodal

[/td][td=bgcolor:#000000]

Hall Side Intermodal

[/td][td=bgcolor:#000000]

Bin

[/td][td=bgcolor:#000000]

DAW

[/td][td=bgcolor:#000000]

EX metal

[/td][td=bgcolor:#000000]

Metal

[/td][td=bgcolor:#000000]

Time (in Min)

[/td][td=bgcolor:#000000]

Customer

[/td][td=bgcolor:#000000]

Total to Bin

[/td][td=bgcolor:#000000]

Total to Inc

[/td][td=bgcolor:#000000]

Total to Comp

[/td][td=bgcolor:#000000]

Disputes

[/td][td=bgcolor:#000000]

NOTES

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2

[/td][td=bgcolor:#FF0000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3

[/td][td=bgcolor:#000000]

JC 12/15/2018

[/td][td=bgcolor:#000000]

766535

[/td][td=bgcolor:#000000]

5385

[/td][td=bgcolor:#000000]

X

[/td][td=bgcolor:#000000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#000000]

X

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

5385

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4

[/td][td=bgcolor:#000000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5

[/td][td=bgcolor:#000000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6

[/td][td=bgcolor:#000000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7

[/td][td=bgcolor:#000000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8

[/td][td=bgcolor:#000000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

0

[/td][td=bgcolor:#000000]

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: DOWNTIME[/td][/tr][/table]

extracting info

Countryboy69

Board Regular

Excel Facts

Countryboy69

Board Regular

Macropod

Retired Moderator

Countryboy69

Board Regular

Macropod

Retired Moderator

Countryboy69

Board Regular

Countryboy69

Board Regular

Countryboy69

Board Regular

TotallyConfused

Board Regular

Countryboy69

Board Regular

Similar threads

Forum statistics

Share this page

extracting info

Board Regular

Excel Facts

Board Regular

Retired Moderator

Board Regular

Retired Moderator

Board Regular

Board Regular

Board Regular

Board Regular

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock