OK, initially:- The "Main" sheet is protected (luckily, without a password).
The protection does not allow locked cells to be selected. The sheet was
protected with the a locked cell selected. Therefore, when the macro tries to
select the sheet "Main", an error occurs.Solution: Unprotect the sheet, select
Cell B2, then re-protect the sheet.
- In the macro "MapAndConsolidate": There is a group of lines that have
issues:----------------------------------------------------------------------
'* Added this line
Set wbFOP = Workbooks(FinalOutP)
If wbFOP Is Nothing Then Set wbFOP = Workbooks.Open(Filename:=filePath &
Application.PathSeparator & FinalOutP)
If wbFOP Is Nothing Then GoTo exitNoGo
FinalOutput = "Final_Output-" & Format(Now(), "dd-mm-yyyy-HHmm") & "_" &
Trim(Acronym) &
".xlsx"----------------------------------------------------------------------------------
wbFOP has not been declared (should it be wbFPO ??) FinalOutP has not been
declared (should it be FinalOutput ?) filepath has not been declared or
assigned a value
If FinalOutP should be FinalOutput, then these lines should appear AFTER the
line: FinalOutput = ...
- Near the bottom of the macro, in the following lines:
wsFPO1.Cells.Columns.AutoFit
wsFPO2.Cells.Columns.AutoFit
wsFPO3.Cells.Columns.AutoFit
wsFPO4.Cells.Columns.AutoFit wsFPO4 has not been declared or assigned.
- In order to continue testing, we need the data files specified in B3 and B4.
Without those, I cannot test further.
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
On Friday, February 5, 2016 1:01 AM, Saurabh Karangutkar
<saurabh12...@gmail.com> wrote:
The name of the software is price mapping tool .Here it is what it is intented
to do .
Here is the problem
Sheet 1 - file 1 is base datafile thats maps our master product file with
master product file received from our suppliers / merchants listing supplier
product code to our product code, and supplier name to our name. This is
prepared basis a one time exercise.Sheet 1 - file 2 is daily price list that we
receive from the supplier in that format - it lists down supplier product code,
supplier product name, MRP i.e. list price, selling price - at times this is at
a discount to list price, and quantity available for sale.Sheet 1 - file 3 is
the format in which we need output basis mapping of sheet 1 with sheet 2.
Instructions are given against each field. We use file 3 to upload the file in
our system that calculates final selling price to retail consumers. Our agents
often refer this final file while discussing sales with potential customers.
. The problem is the output sheet is not proper . The output file should have
three sheets . First sheet containing the mapped items , second sheet showing
items whose list price information is not available and third sheet showing
that multiple Price records found
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
