Hi so I have a spreadsheet that comes to me weekly that I need to do a few things to. Basicly in sheet one I fill in a code and it pulls in data from sheet 2. This results in two sets of data. I want to be able to make a marco that says IF C11:C21 = Blank ( i.e the formula doesn't result in anything) then delete those rows. and then I want to do the same things for C31:33 if = no result from IF forumula blank out those values. I also want to be able to do something that resizes the row height of the rows with data in them. I am doing this now manually via this code :
Could anybody help me with this. This is what the sheet looks like filled in sometimes it will spit out #N/A in the first section in row d if there is nothing resulting from the formulaPlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks