Copy multiple cells info from sheet if value greater than 0 in another cell
Closed
Tbonekiller
Posts
15
Registration date
Wednesday August 21, 2019
Status
Member
Last seen
July 20, 2022
-
Updated on Jan 24, 2021 at 06:10 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 24, 2021 at 06:37 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 24, 2021 at 06:37 AM
Related:
- Copy multiple cells info from sheet if value greater than 0 in another cell
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- //192.168.l.0 - Guide
- Sum if greater than and less than cell value ✓ - Excel Forum
- Which key is used to make multiple line in a single cell - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jan 24, 2021 at 06:37 AM
Jan 24, 2021 at 06:37 AM
Hello TBone,
My understanding of your explanation and sample code is:-
- You have numeric values in Column C of a worksheet named "WIP Schedule".
- In the "WIP Schedule" sheet, if any cell in Column C has a value greater than 0 (zero), then cells from Columns E, F and H on the same row need to be copied to cells C3, C6 and D1 respectively in a worksheet named "Regular".
- Immediately after the relevant cell data has been transferred to the "Regular" sheet, the data on the "Regular" sheet, with the newly transferred data from the "WIP Schedule" sheet, needs to be printed out.
- I'm assuming that you have headings in Row2 in the "WIP Schedule" sheet with data starting in Row3.
- With this line of code:-
I'm assuming that you are calling another macro to do the printing.
Is my understanding correct?
It would also be very helpful for potential helpers if you uploaded a sample of your workbook to a free file sharing site such as WeTransfer or Drop Box then posted the link to your sample file back here.
Make sure that your sample is an exact replica of your workbook showing actual inputs and the expected outputs. If your data is sensitive, then please use dummy data. A dozen or so rows of data will suffice for us to work with.
Please ensure that any code that you already have is included in the sample.
Cheerio,
vcoolio.
My understanding of your explanation and sample code is:-
- You have numeric values in Column C of a worksheet named "WIP Schedule".
- In the "WIP Schedule" sheet, if any cell in Column C has a value greater than 0 (zero), then cells from Columns E, F and H on the same row need to be copied to cells C3, C6 and D1 respectively in a worksheet named "Regular".
- Immediately after the relevant cell data has been transferred to the "Regular" sheet, the data on the "Regular" sheet, with the newly transferred data from the "WIP Schedule" sheet, needs to be printed out.
- I'm assuming that you have headings in Row2 in the "WIP Schedule" sheet with data starting in Row3.
- With this line of code:-
Application.Run Range("g3").Text
I'm assuming that you are calling another macro to do the printing.
Is my understanding correct?
It would also be very helpful for potential helpers if you uploaded a sample of your workbook to a free file sharing site such as WeTransfer or Drop Box then posted the link to your sample file back here.
Make sure that your sample is an exact replica of your workbook showing actual inputs and the expected outputs. If your data is sensitive, then please use dummy data. A dozen or so rows of data will suffice for us to work with.
Please ensure that any code that you already have is included in the sample.
Cheerio,
vcoolio.