Previous Topic Next Topic

Writing a Macro

Closed
SabKeel Posts 3 Registration date Wednesday April 15, 2015 Status Member Last seen April 16, 2015 - Apr 15, 2015 at 01:25 PM
SabKeel Posts 3 Registration date Wednesday April 15, 2015 Status Member Last seen April 16, 2015 - Apr 16, 2015 at 05:32 AM
I am struggling trying to figure out how to move data to a new line by inserting and not copying over other data, plus removing data based on specific criteria; any help/guidance would be greatly appreciated... is this even doable? I am about to lose my mind going around and around with this. I am attaching an image of data as it is exported from another application in a csv format (minus the headings - Row 1) and you will see the explanation of what I need in the image. Thank you in advance for any assistance you may be able to provide.

1 response

Answer 1 / 1
ozone_ Posts 1518 Registration date Sunday July 12, 2009 Status Member Last seen June 2, 2023
Apr 15, 2015 at 04:03 PM
Hi there,

The first table has always 4 lines ?
0
SabKeel Posts 3 Registration date Wednesday April 15, 2015 Status Member Last seen April 16, 2015
Apr 15, 2015 at 04:33 PM
No - sorry... it could range between 1 to 100 lines.
0
ozone_ Posts 1518 Registration date Sunday July 12, 2009 Status Member Last seen June 2, 2023
Apr 16, 2015 at 04:29 AM
OK ! and there are more than 3 customers ? Or 3 is the maximum ?
0
SabKeel Posts 3 Registration date Wednesday April 15, 2015 Status Member Last seen April 16, 2015 > ozone_ Posts 1518 Registration date Sunday July 12, 2009 Status Member Last seen June 2, 2023
Apr 16, 2015 at 05:32 AM
Actually, a max of 10 customers. Sorry again.
0

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses