Fill cell with test based on another cells numeric value

**dad812** · 07-01-2018, 07:40 PM

I have multiple sheets that are all the same in a workbook - 13 in all, I am needing to fill cell B51 sheet2 with text from B51 sheet1 based on if a dollar value cell R51 sheet 2 is > 0, if dollar value = o then leave/make B51 sheet2 blank or empty

this will be the same for the next 12 worksheets, example:
B51 sheet3 with text from B51 sheet2 based on if a dollar value cell R51 sheet3 is > 0, if dollar value = 0 then leave/make B51 sheet3 blank or empty

Thank you in advance

**FDibbins** · 07-01-2018, 07:54 PM

Hi, welcome to he forum

1st, I would ask why you have 13 sheets? Do they all contain data?

**dad812** · 07-01-2018, 08:01 PM

12 sheets are month sheets + 1 sheet for additional data.
the 1st. sheet is populated for what is current data and throughout the year the value of a certain cell(R51) will become 0, when that happens I no longer want the previous months text brought forward.

Also, about 10 rows in all, I figure I can use the solution for all rows just change the Row identifier.

**FDibbins** · 07-01-2018, 08:29 PM

It is the generally accepted method to have all data on 1 sheet, then run extracts, summaries etc from that.

There is no "easy" way to copy a formula in sheet1 that references, say, sheet2, to sheet2 and have it change to reference sheet3 now.

Can I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**dad812** · 07-01-2018, 09:01 PM

I will be able to upload a sample tonight or tomorrow. thanks

**dad812** · 07-01-2018, 09:22 PM

example part is located on bottom of sheet

**FDibbins** · 07-01-2018, 10:17 PM

If you add a date to each entry, you could still have everything on 1 sheet, and that will make summaries far simpler

**dad812** · 07-02-2018, 07:13 AM

Thanks for your help, I believe this can be accomplished using VBA keeping the same workbook structure. I will close and repost.

Fill cell with test based on another cells numeric value

LinkBack

Thread Tools

Rate This Thread

Display

Fill cell with test based on another cells numeric value

Re: Fill cell with test based on another cells numeric value

Re: Fill cell with test based on another cells numeric value

Re: Fill cell with test based on another cells numeric value

Re: Fill cell with test based on another cells numeric value

Re: Fill cell with test based on another cells numeric value

Re: Fill cell with test based on another cells numeric value

Re: Fill cell with test based on another cells numeric value

Thread Information

Users Browsing this Thread

Similar Threads

Copy and fill down a numeric+text value but dont change numeric value

Fill out different cells based on value in one cell

Fill Cells based on another cell value

Test two cells and set a third cell with different values depending on test results

[SOLVED] Test if a cell is within a name range and return a text value based on the test

Test Cells if they are numeric

Adding Cells based off a set numeric value from another cell

Bookmarks

Bookmarks

Posting Permissions