Hello,
I am trying to take a file with multiple tabs and combine into one sheet. I was able to do this using the Crew Macro "Wildcard Input" to combine all tabs into two columns, however there are blank cells within the data.
In excel I can click F5, special, blanks, right click delete and have all cells shift up. Can I replicate the ability to remove blanks cells and shift cells up by rows?
Thank you
Solved! Go to Solution.