Standard Template Update from Working File automatically

[Guna13]

Hello,

As a newbie to VBA macros, I've started working with Sheet Update, Range Consolidation, and a small, small macro. Unfortunately, I am struggling to update this Standard Template description information from the Master Working File automatically. (Because in between multiple lines are blanks & Total are there)


Using the Comp wise Sumif Total, I need to update BPC Template information from the Working File.

Second Question:- Copy and paste column count based on Comp Count ( Working File M Column Count). Based on A Column Description, get the sumif value from the working file.

Template Details Fill automatically - Community.xlsx
	A	B	C	D
1	P&L CONSOLIDATED by BUSORG- (DATASOURCE) - 7/27/2022 10:25:54 PM
2	Eentir
3	ALL_BPPL - BUSINESS PARTNER & PRODUCT LINE
4	FISCAL YEAR 2022
5	ACTUALS AND FORECAST
6	CURRENCY = USD
7		MFG_ASIA_PAC_135	MFG_ASIA_PAC_232	MFG_ASIA_PAC_135
8		USD	USD	USD
9	3000 - Gross Sales: External	(1,652,063,306.20)	(32,074,059.27)	-
10	3001 - Gross Sales: External (VIR) - (Dormant)
11	3010 - Other NRE Recovery Revenue	(33,577,215.68)	(3,582,823.17)
12	3011 - NRE D&E Recovery Revenue - Preproduction Activity
13	3012 - NRE Tooling Recovery Revenue - Preproduction Activity
14	3013 - NRE Ramp Up Activities - Preproduction Activity
15	3014 - D&E and Tooling Recovery Revenue - DSN Activity
16	301 - Non-Recurring Sales Activities and Other Cost Recovery	(1,685,640,521.88)	(35,656,882.44)	-
17	3031 - Sales – PPV Recovery from Customer
18	3032 - Sales – PPV Reimbursement to Customer
19	3033 - Sales Freight In Recovery
20	3034 - Sales Material Loss Recovery from Customer
21	3035 - Sales Other Cost Recovery
22	3036 - Sales Freight Out Recovery
23	3037 - Sales Material Loss Recovery and Waste from Non Customers
24	3038 - Sales Inflation Recovery
25	3005 - Gross Sales: Recoveries	-	-	-
26	3020 - Discounts Taken: External
27	3022 - Rebates Taken: External
Output

Cell Formulas
Range	Formula
B16:D16	B16	=SUM(B9:B15)
B25:D25	B25	=SUM(B17:B24)

Your support and assistance are greatly appreciated

 

[MCLIFTO8]

You're using a lot of jargon i don't understand. Can you explain the question more clearly?

I've started working with Sheet Update, Range Consolidation, and a small, small macro. Unfortunately, I am struggling to update this Standard Template description information from the Master Working File automatically. (Because in between multiple lines are blanks & Total are there)

I take it you wrote a macro and it's not updating your sheet because you have some blank rows. Can you share the macro?

Using the Comp wise Sumif Total, I need to update BPC Template information from the Working File.

Comp wise, is that this? AWB CompWise what is the SumIf total in this context?
Nothing on your sheet says anything about this "BPC" acronym. I'm assuming you mean the sheet in your question.
The working file, what does this look like?

Second Question:- Copy and paste column count based on Comp Count ( Working File M Column Count). Based on A Column Description, get the sumif value from the working file.

I am very confused on this whole sentence.

You need to rewrite your question without the business jargon and references to files you haven't shown us.
Contrive some examples if it's sensitive information.

eg.
I have data in "workbook A" "Sheet1", it looks like this.
*insert a small table*
I have data in "workbook B" "sheet 1" it looks like this.
*insert a small table*

question 1
I need a formula in "workbook B", cell "R1A1" that will tell me the column count of "workbook A" "Sheet 1".

question 2
I need some VBA to ..... this is what i currently have.
*insert VBA*

 

[Guna13]

@MCLIFTO8 - this one is completed, thanks for your Info and Question.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Update Template Information from working File automatically
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Guna13]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Update Template Information from working File automatically
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Ok Sir, Noted, thanks for your valuabale Advice. i posted one thread last day with Link. kindly help me