Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel macro

Comment:

I am new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 in cell B2) I need a macro to create the following output in Sheet 2 a1,b1 (combines cells A1 and B1, separate by a comma) END (add this string after every row) a2,b2 END Please note that the number of rows in the input varies. This example shows two, but it could range from one to over 500. Thanks.

Name: chnos
Date: January 4, 2005 at 00:45:12 Pacific

Reply:

no macro needed . On sheet 2, Use concatenate(cellA1;",";cellB1) if result to be A1,B1. Enter "End" one line / each 2. u can concatenate as many cell u want to.

0

change font in right clic...

Excel VLOOKUP

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I'm looking for some help running an excel macro as an automated task. The macro is supposed to create a data connection, import some data from a particular database, apply some formatting and formul...

Summary: Well see, the CSV is from the university database. It's the info on all the classes for the semester. Currently the university has no was to make postable schedules for each room. Thus, this excel mac...

Summary: Hi, I've got a horrible problem with my Excel macro. When I my macro reads a value from a cell containing e.g. 1.33, he reads 1.38! The type of variable where I store it in is a double. The commands I...