tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I thought this would be easy but once again, No! so please help if you can
I have input column in sheet "Sold" Column "A"
in here we add a number say 100 (whatever row i paste into is the first row of the copied data)
then in my "product" sheet I have a list of all my items,
so i need to filter "Product" Column D for "100"
Then copy and paste however many rows i got into the sheet "Sold"
But I want
whats in "Product" Column "A" to go Into "Sold" Column "J"
whats in "Product" Column "C" to go Into "Sold" Column "F"
whats in "Product" Column "L" to go Into "Sold" Column "B" (All just values)
now just to make it more complicated, there is data in the rows below so first i need to instert Rows into sheet "Sold" but only Columns A:M (shift down)
please help if you can
thanks
Tony
I thought this would be easy but once again, No! so please help if you can
I have input column in sheet "Sold" Column "A"
in here we add a number say 100 (whatever row i paste into is the first row of the copied data)
then in my "product" sheet I have a list of all my items,
so i need to filter "Product" Column D for "100"
Then copy and paste however many rows i got into the sheet "Sold"
But I want
whats in "Product" Column "A" to go Into "Sold" Column "J"
whats in "Product" Column "C" to go Into "Sold" Column "F"
whats in "Product" Column "L" to go Into "Sold" Column "B" (All just values)
now just to make it more complicated, there is data in the rows below so first i need to instert Rows into sheet "Sold" but only Columns A:M (shift down)
please help if you can
thanks
Tony