trivrain
12-21-2010, 09:00 AM
Hi all,
I am looking for codes that would do the following, but I have no knowledge of VBA language:
For columns A, B, C in worksheet 3
- if cell Ax, Bx, and Cx are empty do nothing
- if only one cell has data (Ax or Bx or Cx) simply copy into cell Lx of worksheet 1
- if cell Ax has data, Bx has data and Cx is empty join content like this in Lx of worksheet 1: Ax // Bx
- if cell Ax has data, Bx is empty and Cx has data join content like this in Lx of worksheet 1: Ax // Cx
- if cell Ax is empty, Bx has data and Cx has data join content like this in Lx of worksheet 1: Bx // Cx
- If all have data, join like this in Lx of worksheet 1: Ax // Bx // Cx
For columns D and E in spreadsheet 3
- If cell Dx has data, and Ex is empty, simply copy into Mx in worksheet 1
- If cell Dx is empty, and Ex has data, prefix Ex content with "2" and copy to Mx in worksheet 1
- If both cell have data, prefixe Dx with "1" and Ex with "2" and join content like this in Mx of worksheet 2: "1" Dx / "2" Ex"
Anybody feeling up to it ?
Thank you, t
I am looking for codes that would do the following, but I have no knowledge of VBA language:
For columns A, B, C in worksheet 3
- if cell Ax, Bx, and Cx are empty do nothing
- if only one cell has data (Ax or Bx or Cx) simply copy into cell Lx of worksheet 1
- if cell Ax has data, Bx has data and Cx is empty join content like this in Lx of worksheet 1: Ax // Bx
- if cell Ax has data, Bx is empty and Cx has data join content like this in Lx of worksheet 1: Ax // Cx
- if cell Ax is empty, Bx has data and Cx has data join content like this in Lx of worksheet 1: Bx // Cx
- If all have data, join like this in Lx of worksheet 1: Ax // Bx // Cx
For columns D and E in spreadsheet 3
- If cell Dx has data, and Ex is empty, simply copy into Mx in worksheet 1
- If cell Dx is empty, and Ex has data, prefix Ex content with "2" and copy to Mx in worksheet 1
- If both cell have data, prefixe Dx with "1" and Ex with "2" and join content like this in Mx of worksheet 2: "1" Dx / "2" Ex"
Anybody feeling up to it ?
Thank you, t