Copy cells in excel if cell above is null
Closed
Tara
-
Mar 14, 2012 at 09:42 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Mar 15, 2012 at 05:32 AM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Mar 15, 2012 at 05:32 AM
Hello,
Can anyone help?
I need to run a script that will determine if a1 is blank, paste the information from a2 into the a1. If a1 is not null, it should do nothing. This needs to be run for every other cell. If a3 is null, paste information from a4. If a3 is not null, do nothing. And so on, and so on.
Any ideas?? Thanks in advance!
Can anyone help?
I need to run a script that will determine if a1 is blank, paste the information from a2 into the a1. If a1 is not null, it should do nothing. This needs to be run for every other cell. If a3 is null, paste information from a4. If a3 is not null, do nothing. And so on, and so on.
Any ideas?? Thanks in advance!
Related:
- Copy cells in excel if cell above is null
- Number to words in excel - Guide
- Gif in excel - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Count if cell contains number - Excel Forum
- Excel mod apk for pc - Download - Spreadsheets
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 15, 2012 at 02:19 AM
Mar 15, 2012 at 02:19 AM
why not just sort column A
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Mar 15, 2012 at 05:32 AM
Mar 15, 2012 at 05:32 AM
Hi,
Try this macro :
Best regards
Try this macro :
Sub CompleteEmptyCell() x = Range("A65536").End(xlUp).Row For y = 1 To x If Range("A" & y) = "" Then Range("A" & y) = Range("A" & y + 1) Next End Sub
Best regards