Countryboy69
Board Regular
- Joined
- Dec 7, 2018
- Messages
- 77
is there a macro that once an external file is open it pulls certain info from it and plugs it in to various sheets?
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
“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?
place your code here
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | JC 12/15/2018 | | | MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY | | | | | | | | INC BOX | | D-box | Disputes | | D.A.W | |
2 | Barcode | Daughter B/C | W.A.D. | Full wt. | Empty wt. | Waste Wt. | Types | Destination | NPC/PSC | Notes | Full Wt. | Empty Wt. | Box # | Full Wt. | Full Wt. | Empty Wt. | Full Wt. | Empty Wt. |
3 | 766535 | | | 7890 | 2505 | 5385 | 20 | BIN | | | | | | | | | | |
4 | | | | | | 0 | | | | | | | | | | | | |
5 | | | | | | 0 | | | | | | | | | | | | |
6 | | | | | | 0 | | | | | | | | | | | | |
7 | | | | | | 0 | | | | | | | | | | | | |
Sheet: NOTES |
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | Barcode | Waste WT | 40 S/l | 20' S/l | B-25 | Drum | Exelon | Other | | Bin Side Intermodal | Hall Side Intermodal | Bin | | DAW | EX metal | Metal | Time (in Min) | Customer | Total to Bin | Total to Inc | Total to Comp | Disputes | NOTES |
2 | | | | | | | | | | | | | | | | | | | | | | | | |
3 | JC 12/15/2018 | 766535 | 5385 | | X | | | | | | | | X | | 0 | | | | | 5385 | 0 | 0 | 0 | 0 |
4 | | | | | | | | | | | | | | | 0 | | | | | | 0 | 0 | 0 | |
5 | | | | | | | | | | | | | | | 0 | | | | | | 0 | 0 | 0 | |
6 | | | | | | | | | | | | | | | 0 | | | | | | 0 | 0 | 0 | |
7 | | | | | | | | | | | | | | | 0 | | | | | | 0 | 0 | 0 | |
8 | | | | | | | | | | | | | | | 0 | | | | | | 0 | 0 | 0 | |
Sheet: DOWNTIME |