Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from TRUE

**junni92** · 03-15-2019, 02:47 AM

hai,
background: 2columns, 1column is already coded to identify (date, as an input) in which month and year it falls and calculates the remaining days in that month and the no. of days in following months....
problem: the second column ( a set of values in a column) is required to start from where the days in first column starts....
PS: without vba is appreciated...

Thanks in advance

**bebo021999** · 03-15-2019, 03:00 AM

Worksheet or image at least is required...

**alansidman** · 03-15-2019, 03:01 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**junni92** · 03-15-2019, 04:06 AM

Thankyou guys for your speedy reply. Especially alansidman for letting me know about attachments (i tried but couldn't figure it out earlier).
I have attached a sample workbook, hopefully letting you know what i desire.

Hoping for a fruitful reply.

**JeteMc** · 03-16-2019, 09:47 AM

Try pasting the following into C5 then double click the fill handle to copy down: =IFERROR(IF(B5="","",INDEX(D$5:D$41,SUMPRODUCT(--(B$5:B5<>"")))),"")
Let us know if you have any questions.

**junni92** · 03-17-2019, 09:31 AM

It worked. Thanq every one, really appreciate your help.

**JeteMc** · 03-17-2019, 02:20 PM

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from TRUE

LinkBack

Thread Tools

Rate This Thread

Display

Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from TRUE

Re: Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from

Re: Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from

Re: Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from

Re: Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from

Re: Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from

Re: Copy a column when a if logic in adjacent cell is TRUE.Copied colum should start from

Thread Information

Users Browsing this Thread

Similar Threads

If cell has strikethrough, state true in adjacent column

[SOLVED] Copy Cell Value if adjacent is true

[SOLVED] Count smallest two against a figure in another column and use logic to get true or false

Checkbox true = always start in correct cell?

Writing IF functions where 'Logic Test' is text string and 'value true' is cell reference

Macro to Copy a Cell from a Range When Adjacent Cell = TRUE and Paste to Different Sheet

Excel 2007 : Identify a word in random strings in a column and mark adjacent Column true or false.

Bookmarks

Bookmarks

Posting Permissions