VBA macro for copying and pasting X times by week

Szajbus37 · Apr 18th 2022

Hi
I want to create some VBA to copy bcode(from inventory B column) and when i click specific keybinds macro will start and I putting a number in the box or something how many times this bcode must be copied to scanner data in last row based on date week

Any ideas ?

**royUK** · Apr 25th 2022

You need to explain more fully what you mean.

If you are looking to count then using SUMIFS or a PivotTable would be the best way, but your data is not very well laid out for any use.

VBA macro for copying and pasting X times by week

Participate now!

Share

Similar Threads

Changing file name and dates VBA macro

COPY PASTE DATA FROM MASTER WORKBOOK TO ALL WORKBOOKS IN THE FOLDER BASED ON CRITERIA