Help with Formula's please and thank you

Jess84

New Member
Joined
Jun 20, 2017
Messages
6
Office Version
  1. 365
Platform
  1. Windows
I'm looking for some help with my spread sheet. I have uploaded a snip and excel as an example
I'm wanting data from 1 tab to automatically update on other tab. I sort of know how to do that with 1 cell but I'm thinking what i'm asking for in the snip might either be very complex or not able to be done. I'm also open to suggestions on other ways around this.
The reason for this is ordering building material and keeping a tab on stock lvls
Im trying to make my work days easier :):)


Example.xlsx
ABCDEFGHIJKLMNOP
1NameSUBURBJob NoDCCouncil Poly CarbColourStart Completion of floorCompletion roof/frameCompletion of DeckOtherCompletionH.O.W APPLIED
2No Approval Needed
3SmithE12356NAMGCool Riverstone
4SmithE12458NANA
5SmithE12583NAMGCool Riverstone
6
7LEAVE BLANK
8No Approval Needed
9SmithE19678NASUP/TGCool Riverstone
10SmithE20406NATGC/Grey
11SmithE20721NANA
12
13LEAVE BLANK
14No Approval Needed
15
16LEAVE BLANK
17No Approval Needed
18SmithE20456NAMG Cool Graphite
19SmithE20526NAMGCool Mist
20SmithE20616NASGIce Clear
21SmithE20735NATGC/Silver
22
23LEAVE BLANK
24No Approval Needed
25
26LEAVE BLANK
27No Approval Needed
28SmithE20317NATGC/Mist
29SmithE20558NANA
30
31LEAVE BLANK
32Council Jobs
33SmithE18662$12,048.00SGIce Silver
34SmithE20618$7,300.00TG
35SmithE20679$2,000.00NA
36SmithE20690$4,000.00MG
37
38LEAVE BLANK
39Council Jobs
40SmithE20181$5,400.00MG/TG
41SmithE20493$1,155.00NA
42SmithE20557$2,200.00NA
43SmithE20560$3,200.00MG
44SmithE20590$25,704.00NA
45SmithE20698$4,400.00NA
46
47LEAVE BLANK
48Council Jobs
49SmithE20453$2,500.00MG/TG
50SmithE20436$5,869.00NA
51SmithE20505$1,900.00MG & TG
52SmithE20654$5,000.00MG/TG
53SmithE20459$2,760.00NA
54SmithE20682$3,000.00NA
55SmithE20728$8,000.00NA
56
57
58Council Jobs
59SmithE17210$1,910.00NA
60
61
62Council Jobs
63
64
65Council Jobs
66SmithE18304$2,200.00NA
Sheet1



Example.xlsx
ABCDEFGHIJKLMNOP
1Not ordered & OrderedCouncilNot ordered & Ordered
2MultiGlaze - Cool Riverstone MultiGlaze - Cool Riverstone SuperGlaze
3Job Job Number360082005850Job Job Number360082005850Job Job Number36008200
4
5
6
7Not ordered & OrderedCouncil
8MultiGlaze - Cool Graphite MultiGlaze - Cool Graphite
9Job Job Number36008200Job Job Number36008200
10
11
12
13Not ordered & OrderedCouncil
14MultiGlaze - Cool Mist MultiGlaze - Cool Mist
15Job Job Number36008200Job Job Number36008200
16
17
18
19Not ordered & OrderedCouncil
20SolidGalze - Ice ClearSolidGalze - Ice Clear
21Job Job Number36008200Job Job Number36008200
22
23
24
25Not ordered & OrderedCouncil
26SolidGalze - Ice SilverSolidGalze - Ice Silver
27Job Job Number36008200Job Job Number36008200
28
29
30
31Not ordered & OrderedCouncil
32SolidGalze - OpalSolidGalze - Opal
33Job Job Number36008200Job Job Number36008200
34
35
36
37Not ordered & Ordered
38TwinGlaze
39Job Job NumberColour8200x1200
40C/Grey
41C/Silver
42C/Mist
43
44COUNCIL
45TwinGlaze
46Job Job NumberColour8200x1200
47C/Grey
48C/Grey
49C/Silver
50C/Mist
Sheet2
 

Attachments

  • Excel.png
    Excel.png
    128.9 KB · Views: 21

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Hi Jess84 - I see that nobody has responded yet so I thought I would try to help get you started. If I understand correctly - you want to import data after removing some column values. If that is correct, why not just duplicate the tab and then remove the columns (B, D, E, F) and then copy over the data. This is fairly easy to do if that is what you want. Hope this helps.
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top