Is there a formula I can use in with conditional formatting that if a specific text like “Good “ was entered into cell A1 of sheet1 that A2 sheet1 data would then be copied and place in next
Is there a formula I can use in with conditional formatting that if a specific text like “Good “ was entered into cell A1 of sheet1 that A2 sheet1 data would then be copied and place in next
Last edited by ABabeNChrist; 03-06-2010 at 11:45 AM.
Conditional formatting cannot copy or move data to another location. A macro (or possibly a good formula) would be required for this.
Hi Paul
Like a Worksheet_Change Event
I looked around for samples to get some ideas how I may achieve this, no such luck.
Thats why I was thinking possibly a formula.
You can use a Worksheet_Change event, but I'd recommend posting a sample of your worksheet showing where you would enter data, and where/how you'd like it to end up (and why).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks