Hi Azhar,
Try using a variable for your file name. This variable file name can
be driven from the mail merge data set or from an adjacent data set.
Alvin
On Jun 15, 8:08 pm, Azhar Rai wrote:
> Hi All
>
> Finally I have recorded the following macro code:
>
> Sub reports()
> '
> ' reports Mac
Hi Kristin,
Have you got an email I can send a file sample to? I cant seem to
attached a file in here.
Alvin
On Jun 15, 2:32 am, Kristin wrote:
> I am trying to create 3 columns for an ongoing monthly master
> spreadsheet. The data includes: Product Name (highest level of info),
> Product I
Excel.
fongie
On Jun 20, 2:58 pm, Chaudhry Zahid Ali
wrote:
> Dear All,
>
> I have to apply pivot on a data that reaches approx 1.5m rows and is spread
> on 15 columns. If I divide the data in two parts of 0.8m rows each, I can
> not do a complete analysis. Any suggestions???
Hi Ramesh,
I have just sent an email with an example of how this can be done.
Thanks
Alvin Fong
On Jul 9, 7:56 pm, Ramesh-Hyderabad wrote:
> Hello Gurus,
>
> 1. Attached is the sample data what we get from the Server
>
> 2. The raw data might not have all the LEVELS, where as our report
> tem
Hi Wes
Not too sure what the problem is exactly as I have just used
"Data Validation"
=> "Settings"
=> "Allow " = "Text length"
=> "Data" = "less than or equal to"
=> "Length" = "7"
then tested it on a cell with custom format of "000" and it seems
to be OK.
Let me know how you go if this is
Hi Putta,
Try -
= substitute([cell ref],"-","")*(-1)
Thanks
Alvin
On Aug 4, 5:08 pm, Putta Madaiah wrote:
> Hi All,
>
> Can any one tell me the formula to get the value as in Required answer as
> against Original Value.
>
> *Original Value*
> *Required answer*
> 125756.95-
> -125756.95
Hi Osiso,
Can you just clarify what you are trying to do, as it sounds like we
are trying to make this more difficult than it needs to be.
Presumably you have an array of exchange rates from date x (eg 199712)
to date y (eg 200712) on one sheet.
On another sheet you are wanting to pull back the
Hi Osiso
You sent me an email today with another query.
I tried to send back to paraport email but got mail server rejections.
Is there another email I can email you on?
Alvin
On Aug 6, 3:05 am, osiso wrote:
> i would like to add an example of what im trying to do. please let me
> know how t
Hi Sandeep
Did you manage to resolve your problem?
There was the suggestion to take the data into a notepad file. I
tried that but could not get it to work myself.
Did something similar to take the data into MS Word instead then back
to Excel which placed each line of the cell into individual