0

How can I achieve the after where the dates are copied next to the appropriate expenses without having to manually copy paste? I guess the logic is that all the charges copy the date before them which is in bold. Once a new date pops up, the new date is copied down. I am not sure how I would achieve this.

Before:

Before

After:

After

4
  • 1
    I notice that the first line for personB has "PersonB" listed in both columns A and C, but it's not the case for PersonA. Is there a standard way this will be listed? Which is representative of your actual data? Oct 24, 2018 at 14:23
  • Select the range you want and select Ctrl+G- Special- Blanks- select all Blank cells- enter = and ↑ up arrow- Ctrl+Enter, it will fill all cells automatically.
    – Lee
    Oct 25, 2018 at 9:24
  • Welcome to SuperUser. From your public data I see that you have not yet visited the tour. Please do so, and read it to the end, it only takes a minute. Also familiarize yourself with the help center, especially regarding asking. Oct 27, 2018 at 10:14
  • And since your question has been answered, please read What should I do when someone answers my question? Oct 27, 2018 at 10:14

1 Answer 1

1

This works for your example. You can do this a bunch of ways. The quickest might just be to open the VBEditor, open the Immediate Window (CTRL+G), paste this text and hit ENTER

Range("B2:B20").SpecialCells(xlCellTypeBlanks).Formula = "=IF(A2=C2,"""",B1)"

(Adjust that starting range as necessary. Note that you must start at row 2 though, but change the 20 to whatever the end of your data is)

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .