Hi guys,

New here and add an issue I m hoping you can help me with. Here is the
problem:

I work in the pricing Dept for a grocery store. I use excel to do all my
spreadsheet work for tasks like setting up new products that are going into
the stores, creating sale item batches, and comparing sales movements on
items. The problem is that many times vendors send me the new product info in
an excel spreadsheet but the data is never formatted in a way that I can use.
I use a program call BRDATA to handle all of the stores inventory control.

What I want to be able to do and have done up until the acutall formatting
part is this.

-Open the spreadsheet from the outside vendor (completed)
-Grab the column headers and match them up with the appropriate preset
headers that I use (completed) when working with BRDATA
-Based on which preset header the imported columns correspond to, then take
that data and format it to my needs (incomplete!!!!!!!)

I can send or post the code if you guys need it! I have a working Macro with
accompanying form that I can also take a screenshot of and post as well if
you guys show me how.

Any ideas and input would be greatly appreciated!!!

Thanks!!!

Hi
Send what the data looks like when you get it and what you want it to
look like when you are finished.
regards
Paul

Nate Lasko wrote:

Hi guys,

New here and add an issue I m hoping you can help me with. Here is the
problem:

I work in the pricing Dept for a grocery store. I use excel to do all my
spreadsheet work for tasks like setting up new products that are going into
the stores, creating sale item batches, and comparing sales movements on
items. The problem is that many times vendors send me the new product info in
an excel spreadsheet but the data is never formatted in a way that I can use.
I use a program call BRDATA to handle all of the stores inventory control.

What I want to be able to do and have done up until the acutall formatting
part is this.

-Open the spreadsheet from the outside vendor (completed)
-Grab the column headers and match them up with the appropriate preset
headers that I use (completed) when working with BRDATA
-Based on which preset header the imported columns correspond to, then take
that data and format it to my needs (incomplete!!!!!!!)

I can send or post the code if you guys need it! I have a working Macro with
accompanying form that I can also take a screenshot of and post as well if
you guys show me how.

Any ideas and input would be greatly appreciated!!!

Thanks!!!

Well for example every item has a UPC right. A lot of times they will contain
hyphens
8-67789-21003
and I dont want them in. Or I need all caps in the description field.

I know basically how to format the data. I guess what I am looking for is
help in coding how to actually format those columns. I can addin the
specifics on how I want it formatted

" wrote:

Hi
Send what the data looks like when you get it and what you want it to
look like when you are finished.
regards
Paul

Nate Lasko wrote:

Hi guys,

New here and add an issue I m hoping you can help me with. Here is the
problem:

I work in the pricing Dept for a grocery store. I use excel to do all my
spreadsheet work for tasks like setting up new products that are going into
the stores, creating sale item batches, and comparing sales movements on
items. The problem is that many times vendors send me the new product info in
an excel spreadsheet but the data is never formatted in a way that I can use.
I use a program call BRDATA to handle all of the stores inventory control.

What I want to be able to do and have done up until the acutall formatting
part is this.

-Open the spreadsheet from the outside vendor (completed)
-Grab the column headers and match them up with the appropriate preset
headers that I use (completed) when working with BRDATA
-Based on which preset header the imported columns correspond to, then take
that data and format it to my needs (incomplete!!!!!!!)

I can send or post the code if you guys need it! I have a working Macro with
accompanying form that I can also take a screenshot of and post as well if
you guys show me how.

Any ideas and input would be greatly appreciated!!!

Thanks!!!

I was thinking about creating an object that would store the header for each
column, the actual column that it will be formatting, and what type of my
premade formats I would like to use when applying the formatting. I know how
to declare an object but I am not sure how to actually declar the properties
and their types. Can you help me with that??? Also should I just declare one
object or an object for each column that I will be formatting???

"Nate Lasko" wrote:

Hi guys,

New here and add an issue I m hoping you can help me with. Here is the
problem:

I work in the pricing Dept for a grocery store. I use excel to do all my
spreadsheet work for tasks like setting up new products that are going into
the stores, creating sale item batches, and comparing sales movements on
items. The problem is that many times vendors send me the new product info in
an excel spreadsheet but the data is never formatted in a way that I can use.
I use a program call BRDATA to handle all of the stores inventory control.

What I want to be able to do and have done up until the acutall formatting
part is this.

-Open the spreadsheet from the outside vendor (completed)
-Grab the column headers and match them up with the appropriate preset
headers that I use (completed) when working with BRDATA
-Based on which preset header the imported columns correspond to, then take
that data and format it to my needs (incomplete!!!!!!!)

I can send or post the code if you guys need it! I have a working Macro with
accompanying form that I can also take a screenshot of and post as well if
you guys show me how.

Any ideas and input would be greatly appreciated!!!

Thanks!!!

This is one method to format text. Most of this type stuff is in the VBA
help files with examples.

Sub Frmt()
With Worksheets(1).Range("A1:B4").Font
.Name = "Book Antigua"
.Size = 12
.Bold = True
End With
End Sub

"Nate Lasko" wrote:

Well for example every item has a UPC right. A lot of times they will contain
hyphens
8-67789-21003
and I dont want them in. Or I need all caps in the description field.

I know basically how to format the data. I guess what I am looking for is
help in coding how to actually format those columns. I can addin the
specifics on how I want it formatted

" wrote:

Hi
Send what the data looks like when you get it and what you want it to
look like when you are finished.
regards
Paul

Nate Lasko wrote:

Hi guys,

New here and add an issue I m hoping you can help me with. Here is the
problem:

I work in the pricing Dept for a grocery store. I use excel to do all my
spreadsheet work for tasks like setting up new products that are going into
the stores, creating sale item batches, and comparing sales movements on
items. The problem is that many times vendors send me the new product info in
an excel spreadsheet but the data is never formatted in a way that I can use.
I use a program call BRDATA to handle all of the stores inventory control.

What I want to be able to do and have done up until the acutall formatting
part is this.

-Open the spreadsheet from the outside vendor (completed)
-Grab the column headers and match them up with the appropriate preset
headers that I use (completed) when working with BRDATA
-Based on which preset header the imported columns correspond to, then take
that data and format it to my needs (incomplete!!!!!!!)

I can send or post the code if you guys need it! I have a working Macro with
accompanying form that I can also take a screenshot of and post as well if
you guys show me how.

Any ideas and input would be greatly appreciated!!!

Thanks!!!

Well, I am a little bit confused about what you are attempting to do. If you
want to format a range as a column or row header, you have a couple of
options. If you want each column header or row header to have a different
format, then you would have to write code for each one. If you want all the
headers to have the same format, then you only have to write the code once
and apply it to all of the cells in the header range. You can put the range
in a variable container like myRange or hdrRange or whatever name you want to
give it with a statement like:
myRange = Range("A1:F1") which will incorporate the first row of cells in
columns A through F. From then on, you simply refer to those cells as
myRange or whatever you decide to call it. Most properties and types are
established unless you want to create something different or new. That takes
a lot of detailed explanation which you would be better off looking up in
either the VBA help files or by web search in Google or Yahoo. As I said, I
am a little bit confused about what you really are trying to do.

"Nate Lasko" wrote:

I was thinking about creating an object that would store the header for each
column, the actual column that it will be formatting, and what type of my
premade formats I would like to use when applying the formatting. I know how
to declare an object but I am not sure how to actually declar the properties
and their types. Can you help me with that??? Also should I just declare one
object or an object for each column that I will be formatting???

"Nate Lasko" wrote:

Hi guys,

New here and add an issue I m hoping you can help me with. Here is the
problem:

I work in the pricing Dept for a grocery store. I use excel to do all my
spreadsheet work for tasks like setting up new products that are going into
the stores, creating sale item batches, and comparing sales movements on
items. The problem is that many times vendors send me the new product info in
an excel spreadsheet but the data is never formatted in a way that I can use.
I use a program call BRDATA to handle all of the stores inventory control.

What I want to be able to do and have done up until the acutall formatting
part is this.

-Open the spreadsheet from the outside vendor (completed)
-Grab the column headers and match them up with the appropriate preset
headers that I use (completed) when working with BRDATA
-Based on which preset header the imported columns correspond to, then take
that data and format it to my needs (incomplete!!!!!!!)

I can send or post the code if you guys need it! I have a working Macro with
accompanying form that I can also take a screenshot of and post as well if
you guys show me how.

Any ideas and input would be greatly appreciated!!!

Thanks!!!