Hi,
i have a data populated into a column with company name and other data
devided by a comma.
So it looks something like:
AAA Inc., Series1
ABCD Ltd., Class 99
1234 Bank, Some Data 999
and so on
How could i put everything to the left from comma to column B and
everything to the right from comm
I have data in multiple columns like this :
http://spreadsheets.google.com/pub?key=pD3DJDAymrEspkRfQWMOTUg
I'd like data moved to one single column (like column #1)
Can someone help me out with a macro ?
Much appreciated.
Terry
--~--~-~--~~~---~--~~
Visit the b
Thanks alot for the link it is very helpful in thorough understanding of the
formula
On Mon, Nov 17, 2008 at 4:04 AM, Bertone, Joseph S. <[EMAIL PROTECTED]>wrote:
>
> Here you go-
> Great step-by-step
> (it takes a moment or two to load...)
>
>
> http://blogs.msdn.com/excel/archive/2008/10/23/cr
What specifically doesn't work?
Tom
On Wed, Nov 19, 2008 at 2:33 AM, arun p <[EMAIL PROTECTED]> wrote:
> Tom, your combineworksheets macro doesnt work.
>
> regards
>
>
>
> On Sat, Nov 15, 2008 at 8:37 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote:
>
>> Assuming that the Worksheets you want to combin
You can concatenate "Customer Number" and "Proposal Number" and then use
them as one variable to do your VLOOKUP
On Sun, Nov 16, 2008 at 8:55 PM, Mahreen Ellahi <[EMAIL PROTECTED]
> wrote:
> Hi All
>
> I have a little query regarding VLOOKUP Formula. I have been using it
> depending on only one v
Hi All,
My son fits out new houses with cupboard shelving.
He does all his measuring and comes back with data something like:
0.9 metre lengths x 8
1.1 metre lengths x 5
1.4 metre lengths x 11
1.8 metre lengths x 6
2.2 metre lengths x 12
He can only buy shelving in standard lengths - say
Hello.
This is my first message to the group.
My message is not necessarily about MACROS. In fact, I would prefer
not to use MACROS, if that's possible.
I just want to create a cell whose content is restricted to the items
or values in a list. The list would be static, and it wouldn't be a
prob
Hey all-
I have been searching every Excel help site I can find to get a
solution to this. If anyone has any suggestions, it would be awesome.
I have 2 columns of data in a spreadsheet. They look something like
this:
source1
All Visits 1234
Paid1000
Non-Paid 234
source2
All
Consider using a pivot table
On Mon, Nov 17, 2008 at 9:14 PM, Dean <[EMAIL PROTECTED]> wrote:
>
> I have a list of building data. Within that data, there are 15 unique
> towns. I want to know how many times a building of a certain age group
> occurs in each town. There are 13 age groups. For
I am having an exception while addding an Excel Macro using C#. I use
the following code to add a macro.
1. Excel.Application xl = null;
2. Excel._Workbook wb = null;
3. Excel._Worksheet sheet = null;
4. VBIDE.VBComponent module = null;
5. string Macro = "assing a macro"; //to be done
6. xl = new
I think the proper syntax is:While InputSheet.Cells(iInputRow, 2)
.Value <> ""
On Mon, Nov 17, 2008 at 12:10 PM, <[EMAIL PROTECTED]> wrote:
>
> I am trying to input a loop While/Wend with If statements in between
> but it's showing me this code as an error:
>
> While InputSheet.Cells(iIn
I cannot use hyperlink in my pc, when I try to click the link computer
showing the following message.
*"the operation has been canceled due to restriction in effect on this
computer, Please contact your system administrator"*
I'm working on administrative mode. Please help me.
--
aJaY :) (R)™
Rajesh,
There is nothing like better format. This is becuase every business
process is unique. Some things which you might need to work on:
1) Understand the current business process
2) Understand what needs to be accomplished
Based on the above, you could derive design and then construct.
I a
Dear Friends,
This is Rajesh Mishra. I am working as despached executive in a print
house.I want a free sofware or excel format to mantain the daily consumation
of material and incoming stock mantaince on this.If any body have any format
and free software for me .kindly guide me or help me
Tom, your combineworksheets macro doesnt work.
regards
On Sat, Nov 15, 2008 at 8:37 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote:
> Assuming that the Worksheets you want to combine are in the same workbook
> the attached macro CombineWorksheets will combine them into a single sheet
> named "Comb
15 matches
Mail list logo
