• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with Macro please

R

Rebeca Zepeda

New Member
Need macro to copy the document number to each line and then continue with the next document and copy, and so on...please help

[pre]
Code: 
2000	7000270431	$
199983		 $10.19
410100		 $(4.41)
410200		 $(5.78)
199983		 $(10.19)
123000		 $10.19 

2000	7000270432	 $
199983		 $49.20
410100		 $(26.20)
410200		 $(23.00)
199983		 $(49.20)
123000		 $49.20
[/pre]
 
From the example you posted, it's hard to tell what you have currently, and what you what to end up with. Could you elaborate please? Preferably with before/after images?
 
Thank you for your quick reply this is what I need;Copy document number to each line, as the document that I have shows it as a heather for each document

2000 7000270431 $

199983 7000270431 10.19

410100 7000270431 -4.41

410200 7000270431 -5.78

199983 7000270431 -10.19

123000 7000270431 10.19


2000 7000270432 $

199983 7000270432 49.2

410100 7000270432 -26.2

410200 7000270432 -23

199983 7000270432 -49.2

123000 7000270432 49.2
 
1. Select all the relevant cells in the column

2. Hit Ctrl+g to bring up the GoTo box. Click Special Cells

3. Select Blank Cells, ok out

4. Hit the "=" sign, and then, with the edit formula still active, hit the up arrow. This should create a relative reference to cell above.

5. Hit Ctrl+Enter to apply formula to all of these cells.

6. Header should be filled in now.

To lock values, select column, Copy.

7. Right-click, Paste Special, Values. Ok out.
 
Hi Rebeca Zepeda,


Please consider that world is working round the clock, you might have an urgency, but the one who replied you might be sleeping/offline at the moment!


Edit: Sorry he is still available on the forum! :p


Regards & Good Night,

Faseeh
 
opps, I tough that the world was at my service : ) , sorry, thank you very very much have a good night, looking foward to continue in touch
 
You must log in or register to reply here.
Back
Top