I need to copy cells with gaps between:
for example: a1 a3 a5 a7 and paste them with the gaps meaning that when i
paste them there will still be 1 cell apart, but i do not want to copy the
blank cells which exist in between.
thanks jared
I need to copy cells with gaps between:
for example: a1 a3 a5 a7 and paste them with the gaps meaning that when i
paste them there will still be 1 cell apart, but i do not want to copy the
blank cells which exist in between.
thanks jared
Do you mean you want to copy the data on the left and paste it so it looks like the data on the right? IF so you can highlight the entire range on the left, press F5, select "Special" at the bottom of the dialog box and click the radio button for "Constants" and then click "OK". Right click on one of the selected cells and copy the data. Select a destination cell and right click and select paste et voila!
Please Login or Register to view this content.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
Actucally i will probably need to rephrase the question:
let say that the cells which exist are: a1,a2,a3,a4,a5,a6
the only ones which contain information are: a1,a3,a5
how do i copy them to a differenet location so that when i paste them into
b1. the cells which will contain information will be b1 b3 and b5 and not b1
b2 and b3
the tricky part is not copying the blank cells between.
jared
"Excelenator" wrote:
>
> Do you mean you want to copy the data on the left and paste it so it
> looks like the data on the right? IF so you can highlight the entire
> range on the left, press F5, select "Special" at the bottom of the
> dialog box and click the radio button for "Constants" and then click
> "OK". Right click on one of the selected cells and copy the data.
> Select a destination cell and right click and select paste et voila!
>
>
> Code:
> --------------------
> 1 1
> 3
> 3 5
> 7
> 5 9
>
> 7
>
> 9
> --------------------
>
>
> --
> Excelenator
>
>
> ------------------------------------------------------------------------
> Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
> View this thread: http://www.excelforum.com/showthread...hreadid=565432
>
>
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following:
- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following:
- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following:
- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following:
- Highlight the entire range of cells b1 through b6
- Click F5 and select "Special"
- Click the "Blanks" radio button
- Type in +A1 and hit CTL ENTER
- Highlight the range b1 through b6 again and click "Copy"
- Paste Special Values so that the formulas now become values
Are you trying to tell us that there is already data in cells b2,b4, and b6 that you don't want disturbed? IF so you can do the following:
Highlight the entire range of cells b1 through b6
Click F5 and select "Special"
Click the "Blanks" radio button
Type in +A1 and hit CTL ENTER
Highlight the range b1 through b6 again and click "Copy"
Paste Special Values so that the formulas now become values
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks