excell 2016

An Append Querry is created using two seperate tables in a workbook. Table1+Table2= Append1 Now if i make changes or add more data in Table1 or Table2, Will the Apoend1 Query update it self with new Data?. Secondly if i add data in Append1, will it be visible in tables? I am usins Ms exell...

if I have two columns, let me assume its name as X and Y. The X column has decimals in every cell value. --> I want to make the X values as integer numbers by adding the decimal part to the next cell value until the end of the column. --> sure the decimal part present a percentage from the...

Hi, I want to put characters in front of numbers in a cell. The first cell are as you can see "SG17424", but I have to put characters in front of the rest of the cells. It is around 8200 products. <colgroup><col></colgroup><tbody> SG17424 17324 17224...

Hi, I am very new to VBA coding and need some help. I'm looking for a code that selects range, prints to pdf and sends the pdf by e-mail. In my sheet i have 7 cells that have a formula which give the cell a "X" if i want an range to be printed: If I33 = "X" then select A1: S31 (I33 has a...