I have a list of columns A to J.
Column J has the names of the customer, and on
column G there a dollar amount that relates to costumer on on column J
Important note. the column J is sorted in alpha format
I need a macro that groups the list on column J (( based on the name of the
customer )
tem,
the line to create an indication of "grouping items by day" does not work,
and also the subtotal cell is not highlighted in yellow like the others.
I would appreciate you suggestions and comments to see if I can have this
macro works as it is intended
Thank you a whole bunch
tem,
the line to create an indication of "grouping items by day" does not work,
and also the subtotal cell is not highlighted in yellow like the others.
I would appreciate you suggestions and comments to see if I can have this
macro works as it is intended
Thank you a whole bunch
I couldn't upload the sample file, but today I emailed it to group
address.
On Mar 10, 4:20 am, Sanjoy Nath wrote:
> no sample is there.
> One thing more , for this , we can use the formula like
> =indirect(Address(row,column)
>
> and no things like macro is necess
First of all, thank you for all the help that I received so far. You
guys are great.
Today I have the following problem. I have a file where all the data
is on column A. The data is listing the name of a person in row 1,
in row 2 and row 3 it list the address.
from the sample below I like to
itten in column B
>
>
>
> On Wed, Mar 2, 2011 at 12:39 AM, CAN wrote:
> > I have a .CSV file that contains all the data in column A. Each row
> > has different information.
>
> > I am looking for macro that will review the data on each row and
> > whenever find t
I have a .CSV file that contains all the data in column A. Each row
has different information.
I am looking for macro that will review the data on each row and
whenever find the number "12" it will delete it along with all the
information after.
For example see data below
1 MF2-001 B Y MILAGROS
Cells(i, 1).EntireRow.Delete
> End If
> Else
> Cells(i, 1).EntireRow.Delete
> End If
> Next i
> End Sub
>
> Regards.
> Daniel
>
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-mac...@googl
I posted this discussion a few days ago and I haven't hear any answers
on it. Does anyone can help ?
Thank you
-- Forwarded message --
From: CAN
Date: Nov 3, 10:58 am
Subject: Delete rows from a Sheet based on value found on previous
cell
To: MS EXCEL AND VBA MACROS
I h
I have a large excel sheet that contains all the values on Cell A
(this was copied and pasted from PDF).
On each cell under column A there are 3 to 4 rows that below belonfg
to the same customer. In other words a customer can values in A1, A2,
A3 and A4. Then the next customer starts with
ilename = InputBox(" Enter Text File Name ", "Text File")
> FilePath = "c:\download\" & Filename & ".txt"
>
> Set fs = CreateObject("Scripting.FileSystemObject")
> Set a = fs.CreateTextFile(FilePath, True)
>
>
) and field 3 (Date).
After Date the words "echeck" (standard for all records).
After the word echeck there are 4 blank spaces.
The last field after the 4 blank spaces is Net Funded (numeric, 8
digits, no decimals )
I would really, really be greatful and super happy to anyone that can
d
12 matches
Mail list logo
