Hi
I want to copy data (value only) from another sheet to my table with keeping my table format (Using office 2013)
copy the below data
to this below table sheet
i want to paste values only in the first table to match destination formatting
hint: the second sheet has many tables which make it not possible to just copy and paste
I want to copy data (value only) from another sheet to my table with keeping my table format (Using office 2013)
copy the below data
Book1 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
2 | Column2 | Column1 | Column3 | Column4 | ||
3 | 1 | a | a1 | 1/1/2022 | ||
4 | 2 | b | a2 | 1/2/2022 | ||
5 | 3 | c | a3 | 1/3/2022 | ||
6 | 4 | a | a4 | 1/4/2022 | ||
7 | 5 | b | a5 | 1/5/2022 | ||
8 | 6 | c | a6 | 1/6/2022 | ||
9 | 7 | a | a7 | 1/7/2022 | ||
10 | 8 | b | a8 | 1/8/2022 | ||
11 | 9 | c | a9 | 1/9/2022 | ||
12 | 10 | a | a10 | 1/10/2022 | ||
13 | 11 | b | a11 | 1/11/2022 | ||
14 | 12 | c | a12 | 1/12/2022 | ||
15 | 13 | a | a13 | 1/13/2022 | ||
16 | 14 | b | a14 | 1/14/2022 | ||
17 | 15 | c | a15 | 1/15/2022 | ||
18 | 16 | a | a16 | 1/16/2022 | ||
19 | 17 | b | a17 | 1/17/2022 | ||
Sheet2 |
to this below table sheet
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | table 1 | |||||||||||||
2 | Column1 | Column2 | Column3 | Column4 | ||||||||||
3 | QAR 1.00 | s | a | 1-Jan-2022 | ||||||||||
4 | QAR 2.00 | g | y | 2-Jan-2022 | ||||||||||
5 | QAR 2.00 | h | t | 3-Jan-2022 | ||||||||||
6 | QAR 5.00 | |||||||||||||
7 | ||||||||||||||
8 | ||||||||||||||
9 | ||||||||||||||
10 | table 2 | |||||||||||||
11 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | |||
12 | QAR 1.00 | a | d | r | e | e | d | d | j | c | 5-May-2022 | |||
13 | QAR 1.00 | b | e | f | r | e | s | s | k | r | 6-May-2022 | |||
14 | QAR 1.00 | c | f | g | f | w | w | s | g | t | 7-May-2022 | |||
15 | QAR 3.00 | |||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B6,B15 | B6 | =SUBTOTAL(109,[Column1]) |
i want to paste values only in the first table to match destination formatting
hint: the second sheet has many tables which make it not possible to just copy and paste