Forum Discussion
johnsboxftm
Feb 02, 2023Brass Contributor
Having a text formula update automatically across multiple sheets when I add additional information
Hello, all. So I currently have an IFS formula written into cells C3:C30. It's set up so that if I type in a city name it puts in the tax rate so I don't have to type it out constantly for each ...
johnsboxftm
Feb 02, 2023Brass Contributor
Thank you for this, I will implement it shortly, If I may ask, how did you transfer the information from my IFS formula to the columns on sheet 5 when you made the table? Did you have to enter them each individually or is there a way to import that info?
rzaneti
Feb 02, 2023Iron Contributor
1. I just copied your formula and pasted in a cell;
2. After, used the Text to Columns feature, in data tab of the ribbon, to separate it into columns, using comma as separator;
3. Then I copied the whole row and pasted in a cell, using the Transpose paste option, transforming it into a column with cities and tax rates;
4. Then I filtered all of the results by "%", copied it and pasted somewhere else;
5. After have the tax rates properly saved, just deleted all of them from the column and removed the duplicates to delete the blank cells and let only the city names;
6. Finally, I pasted the tax rates (that I saved somewhere else) on the side of the cities.
You can find this table in the file that I sent you in the last comment. In any case, double check it to make sure that I didn't messed with some tax rate in this process 🙂
2. After, used the Text to Columns feature, in data tab of the ribbon, to separate it into columns, using comma as separator;
3. Then I copied the whole row and pasted in a cell, using the Transpose paste option, transforming it into a column with cities and tax rates;
4. Then I filtered all of the results by "%", copied it and pasted somewhere else;
5. After have the tax rates properly saved, just deleted all of them from the column and removed the duplicates to delete the blank cells and let only the city names;
6. Finally, I pasted the tax rates (that I saved somewhere else) on the side of the cities.
You can find this table in the file that I sent you in the last comment. In any case, double check it to make sure that I didn't messed with some tax rate in this process 🙂