Styjun

Why does my String turn into Integers instead of letters after I add characters with +?

Do you know your 'KVZ's?

When casting Eldritch Blast with the Agonizing Blast eldritch invocation, what do I add to my damage roll?

Why are they 'nude photos'?

How would my creatures handle groups without a strong concept of numbers?

Machine learning and operations research projects

How did the hit man miss?

How can I effectively communicate to recruiters that a phone call is not possible?

3D print appears to print very weak walls in long print

Print the last, middle and first character of your code

What does "un pareil soin" mean here?

How to (graphically) present computational results?

definition of "percentile"

Storming Area 51

Setting MAC field to all-zero to indicate unencrypted data

As the Dungeon Master, how do I handle a player that insists on a specific class when I already know that choice will cause issues?

Matchmaker, Matchmaker, make me a match

ESTA: "Is your travel to the US occurring in transit to another country?" when going on a cruise

Was I subtly told to resign?

How do Windows version numbers work?

Are neural networks prone to catastrophic forgetting?

What would be the ideal melee weapon made of "Phase Metal"?

Robbers: The Hidden OEIS Substring

Why isn't there research to build a standard lunar, or Martian mobility platform?

How do I copy and paste values from one range, that has some blank cells, into a new column in excel

Loop through rows to copy and paste specialHow to copy a folder from remote to local using scp?How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loopsFixing my macro to copy a range to the next blank column?Excel VBA to search for up to 15 values in one searchAdd consistent value to cells corresponding with loop and paste specialCopy and Paste to next available columnConditional copy Excel File-2 data to excel file-1?How to change range in sub after copying and pasting data to new sheetTake the date in one worksheet and find the same date in another worksheet column and return the cell reference for that date to use in a loop

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have two worksheets, in one I gather delivery data on amount and date. Some delivery frequencies are weekly, some fortnightly and some monthly.
I need to bring through the delivery volume for the past week into a new sheet, but leave the cell blank if it is outside the 7 day window.
Then in a weeks time, overwrite this information and paste the new amount in a new column so that I can gather average delivery data. So I may have weekly data that ranges from "F3..Z3", but the fortnightly data will only be half of this

I have written vba code to determine the delivery window and bring through to a new sheet but I'm unable to get the data to copy into a new column

I've tried both these -

Range("B:B").Select
Selection.Copy
Range("F:F").End(xlToLeft).Offset(0, 1).Select
 Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, skipblanks:=True, Transpose:=False

and also -

Dim LastRow As Long
LastRow = Sheets("01042019").Cells(Rows.Count, 1).End(xlUp).Offset(1).Row


Sheets("01042019").Range("B3").Copy
Sheets("01042019").Range("XFD3").End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValuesAndNumberFormats

Can you please help?

excel vba copy cell skip

share|improve this question

edited Apr 4 at 8:36

p._phidot_

92111 gold badge44 silver badges1717 bronze badges

asked Mar 26 at 3:19

Janne ButcherJanne Butcher

111 bronze badge

add a comment | 

0

I have two worksheets, in one I gather delivery data on amount and date. Some delivery frequencies are weekly, some fortnightly and some monthly.
I need to bring through the delivery volume for the past week into a new sheet, but leave the cell blank if it is outside the 7 day window.
Then in a weeks time, overwrite this information and paste the new amount in a new column so that I can gather average delivery data. So I may have weekly data that ranges from "F3..Z3", but the fortnightly data will only be half of this

I have written vba code to determine the delivery window and bring through to a new sheet but I'm unable to get the data to copy into a new column

I've tried both these -

Range("B:B").Select
Selection.Copy
Range("F:F").End(xlToLeft).Offset(0, 1).Select
 Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, skipblanks:=True, Transpose:=False

and also -

Dim LastRow As Long
LastRow = Sheets("01042019").Cells(Rows.Count, 1).End(xlUp).Offset(1).Row


Sheets("01042019").Range("B3").Copy
Sheets("01042019").Range("XFD3").End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValuesAndNumberFormats

Can you please help?

excel vba copy cell skip

share|improve this question

edited Apr 4 at 8:36

p._phidot_

92111 gold badge44 silver badges1717 bronze badges

asked Mar 26 at 3:19

Janne ButcherJanne Butcher

111 bronze badge

add a comment | 

I have two worksheets, in one I gather delivery data on amount and date. Some delivery frequencies are weekly, some fortnightly and some monthly.
I need to bring through the delivery volume for the past week into a new sheet, but leave the cell blank if it is outside the 7 day window.
Then in a weeks time, overwrite this information and paste the new amount in a new column so that I can gather average delivery data. So I may have weekly data that ranges from "F3..Z3", but the fortnightly data will only be half of this

I have written vba code to determine the delivery window and bring through to a new sheet but I'm unable to get the data to copy into a new column

I've tried both these -

Range("B:B").Select
Selection.Copy
Range("F:F").End(xlToLeft).Offset(0, 1).Select
 Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, skipblanks:=True, Transpose:=False

and also -

Dim LastRow As Long
LastRow = Sheets("01042019").Cells(Rows.Count, 1).End(xlUp).Offset(1).Row


Sheets("01042019").Range("B3").Copy
Sheets("01042019").Range("XFD3").End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValuesAndNumberFormats

Can you please help?

excel vba copy cell skip

share|improve this question

edited Apr 4 at 8:36

p._phidot_

92111 gold badge44 silver badges1717 bronze badges

asked Mar 26 at 3:19

Janne ButcherJanne Butcher

111 bronze badge

Range("B:B").Select
Selection.Copy
Range("F:F").End(xlToLeft).Offset(0, 1).Select
 Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, skipblanks:=True, Transpose:=False

Dim LastRow As Long
LastRow = Sheets("01042019").Cells(Rows.Count, 1).End(xlUp).Offset(1).Row


Sheets("01042019").Range("B3").Copy
Sheets("01042019").Range("XFD3").End(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValuesAndNumberFormats

share|improve this question

edited Apr 4 at 8:36

p._phidot_

92111 gold badge44 silver badges1717 bronze badges

asked Mar 26 at 3:19

Janne ButcherJanne Butcher

111 bronze badge

share|improve this question

edited Apr 4 at 8:36

p._phidot_

92111 gold badge44 silver badges1717 bronze badges

asked Mar 26 at 3:19

Janne ButcherJanne Butcher

111 bronze badge

edited Apr 4 at 8:36

p._phidot_

92111 gold badge44 silver badges1717 bronze badges

edited Apr 4 at 8:36

p._phidot_

92111 gold badge44 silver badges1717 bronze badges

asked Mar 26 at 3:19

Janne ButcherJanne Butcher

111 bronze badge

asked Mar 26 at 3:19

Janne ButcherJanne Butcher

111 bronze badge